SQL Query for Specific Data | Dataford Interview Questions

How would you write a query to extract specific data from a database?

Use the orders table to return completed orders with an amount of at least 100.

Output

One row per qualifying order with order_id, customer_name, amount, and order_date.
Exclude orders with another status, a missing status, or an amount below 100.
Sort by order_date descending, amount descending, and order_id ascending.

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_name	VARCHAR(100)	Name of the customer who placed the order
amount	DECIMAL(10,2)	Order amount
status	VARCHAR(20)	Current order status
order_date	DATE	Date when the order was placed

Your question is SQL Query for Specific Data. 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.

How would you write a query to extract specific data from a database?

Use the orders table to return completed orders with an amount of at least 100.

One row per qualifying order with order_id, customer_name, amount, and order_date.
Exclude orders with another status, a missing status, or an amount below 100.
Sort by order_date descending, amount descending, and order_id ascending.

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_name	VARCHAR(100)	Name of the customer who placed the order
amount	DECIMAL(10,2)	Order amount
status	VARCHAR(20)	Current order status
order_date	DATE	Date when the order was placed

Your question is SQL Query for Specific Data. 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.