SQL Query for Data Extraction | Dataford Interview Questions

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.

Output

One row per qualifying observation.
Columns: instrument, observation_date, and close_price.
Include only CME rows with close_price >= 100.
Order by observation_date ascending, then instrument ascending.

Schema

market_observations

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

Your question is SQL Query for Data Extraction. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Write a SQL query to extract specific data from a database.

Output

One row per qualifying observation.
Columns: instrument, observation_date, and close_price.
Include only CME rows with close_price >= 100.
Order by observation_date ascending, then instrument ascending.

Schema

market_observations

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

Your question is SQL Query for Data Extraction. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.