SQL Query and Estimation | Dataford Interview Questions

Tell me about how you would write a simple HackerRank SQL query and then make a reasonable guesstimate for burgers sold.

Using the provided burger sales data, write a query that totals burgers from completed orders. Then state a transparent, back-of-the-envelope estimate for a typical 30-day period based on the observed average daily completed sales.

Output

Return one row with total_burgers_sold.
Include only completed orders. The SQL result does not require ordering.

Schema

burger_sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sales record
sale_date	DATE	Date of the recorded sale
burgers_sold	INT	Number of burgers in the sales record
order_status	VARCHAR(20)	Current status of the order

Your question is SQL Query and Estimation. 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 a simple HackerRank SQL query and then make a reasonable guesstimate for burgers sold.

Output

Return one row with total_burgers_sold.
Include only completed orders. The SQL result does not require ordering.

Schema

burger_sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sales record
sale_date	DATE	Date of the recorded sale
burgers_sold	INT	Number of burgers in the sales record
order_status	VARCHAR(20)	Current status of the order

Your question is SQL Query and Estimation. 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.