SQL and Python Fundamentals | Dataford Interview Questions

What basic SQL and Python questions can you answer confidently?

Answer this as a hands-on SQL exercise using the provided sales table. Calculate category-level sales results for the requested categories, ignoring rows with non-positive or NULL amounts.

Output

One row per included category with category, total_sales, and average_sale.
Include only the requested categories and rows with positive, non-NULL amounts.
Order by total_sales descending, then category ascending.

Schema

sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale
category	VARCHAR(50)	Sales category
amount	NUMERIC(12,2)	Sale amount

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