Back to questions
Easy SQL GROUP BY Practice Exercise [SQL Interview Question]
For every FAANG stock in the stock_prices dataset, write a SQL query to find the lowest price each stock ever opened at? Be sure to also order your results by price, in descending order.
Sample stock_prices Input:
| date | ticker | open | high | low | close |
|---|---|---|---|---|---|
| 01/01/2020 00:00:00 | GOOG | 67.08 | 75.16 | 67.08 | 71.71 |
| 01/01/2020 00:00:00 | NFLX | 326.10 | 359.85 | 321.20 | 345.09 |
| 01/01/2020 00:00:00 | AAPL | 74.06 | 81.96 | 73.19 | 77.38 |
| 01/01/2020 00:00:00 | AMZN | 93.75 | 102.79 | 90.77 | 100.44 |
| 01/01/2020 00:00:00 | MSFT | 158.78 | 174.05 | 156.51 | 170.23 |
Example Output:
| ticker | min |
|---|---|
| NFLX | 176.49 |
| AMZN | 85.46 |
| AAPL | 61.63 |
| GOOG | 56.10 |
| META | 94.33 |
| MSFT | 153.00 |
Solution
Use the aggregate function and group by ticker!
Don't forget, to order your results by price, in descending order using the clause. More information on here if you need a refresher!
PostgreSQL 14