Basic SQL Queries and Git | Dataford Interview Questions

Tell me about how you would write basic SQL queries and use Git during a data engineering task.

Using the provided market_data table, write a query that summarizes valid records with positive volume and a non-null closing price. Also explain how you would develop, test, commit, and review the change using Git.

Output

One row per symbol, with symbol and average_close_price
Include the five symbols with the highest average closing price
Sort by average closing price descending, then symbol ascending to break ties

Schema

market_data

Column	Type	Description
record_idPK	INT	Unique market data record identifier
symbol	VARCHAR(12)	Instrument symbol
record_date	DATE	Date of the market observation
close_price	NUMERIC(12,2)	Closing price for the observation
volume	BIGINT	Reported trading volume
status	VARCHAR(16)	Data quality status

Your question is Basic SQL Queries and Git. 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

Tell me about how you would write basic SQL queries and use Git during a data engineering task.

Output

One row per symbol, with symbol and average_close_price
Include the five symbols with the highest average closing price
Sort by average closing price descending, then symbol ascending to break ties

Schema

market_data

Column	Type	Description
record_idPK	INT	Unique market data record identifier
symbol	VARCHAR(12)	Instrument symbol
record_date	DATE	Date of the market observation
close_price	NUMERIC(12,2)	Closing price for the observation
volume	BIGINT	Reported trading volume
status	VARCHAR(16)	Data quality status

Your question is Basic SQL Queries and Git. 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.