SQL · Bloomberg · Medium
Problem You are given a table stock_prices that captures daily stock price data for several FAANG companies. Table schema: Every row in the table is uniquely determined by the combination of date and ticker. Write a query that returns, for each FAANG stock ticker, the month in which it recorded the highest opening price and the month in which it recorded the lowest opening price. Display the month in the format Mon-YYYY (for example, Jan-2023). The output must contain five…
Checking your access…