For Question, assume that a database has a table named stock, with the following columns:
Column Name | Type |
TradingSymbol | CHAR(10) |
CompanyName | CHAR(25) |
NumShares | INT |
PurchasePrice | DOUBLE |
SellingPrice | DOUBLE |
Write a SELECT statement that returns the TradingSymbol column and the NumShares column only from the rows where SellingPrice is greater than PurchasePrice and NumShares is greater than 100. The results should be sorted by the NumShares column in ascending order.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.