Your question is SQL Query for Data Extraction. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Write a SQL query to extract specific data from a database.
Using the supplied market_observations table, return CME observations with a closing price of at least 100. Include the requested columns and sort the results chronologically, using the instrument symbol as the tie-breaker.
instrument, observation_date, and close_price.close_price >= 100.observation_date ascending, then instrument ascending.| Column | Type | Description |
|---|---|---|
| observation_idPK | INT | Unique observation identifier |
| instrument | VARCHAR(20) | Market instrument symbol |
| observation_date | DATE | Date of the market observation |
| venue | VARCHAR(20) | Trading venue |
| close_price | NUMERIC(12,4) | Closing price for the observation |