Basic SQL and Python Prep | Dataford Interview Questions

Basic SQL questions and prepare for basic python questions.

For the SQL portion, write a query using the orders table to identify the five customers with the highest total order amount during January 2024.

Output

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_name	VARCHAR(100)	Customer name
amount	NUMERIC(10,2)	Order amount
order_date	DATE	Date when the order was placed

Your question is Basic SQL and Python Prep. 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.

Basic SQL questions and prepare for basic python questions.

For the SQL portion, write a query using the orders table to identify the five customers with the highest total order amount during January 2024.

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_name	VARCHAR(100)	Customer name
amount	NUMERIC(10,2)	Order amount
order_date	DATE	Date when the order was placed

Your question is Basic SQL and Python Prep. 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.