Explain SQL and Python Basics | Dataford Interview Questions

Bunch of weird stuff about sql. Explain each function, method, etc. Basics for python, what is def, how to write a loop, etc.

For this SQL exercise, write one query that summarizes qualifying customer orders and demonstrates common PostgreSQL query functions.

Output

One row per customer, including customers without qualifying orders.
Return customer_id, customer_name, order_count, total_spend, avg_order_value, categories, customer_tier, and revenue_rank.
Include completed or pending orders from 2024-01-01 through 2024-03-31, exclude cancelled orders, and order by revenue_rank, then customer_id.

customers

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer who placed the order
product_id	INT	Product associated with the order
order_date	DATE	Date the order was placed
order_status	VARCHAR(20)	Order processing status
amount	NUMERIC(10,2)	Order amount

products

Your question is Explain SQL and Python Basics. Start with the requirements and the three tables 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.