CTEs and Data Granularity | Dataford Interview Questions

Write a few CTEs to query a dataset at different levels of granularity. Asked in the technical screen stage. Basic SQL exercise.

Output

One row per region and product_category, plus an overall total row.
Return region, product_category, order_count, total_revenue, and avg_order_value.
Include only completed orders.
Sort with the overall total row last, then by region, then product_category.

orders

Your question is CTEs and Data Granularity. 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.

Write a few CTEs to query a dataset at different levels of granularity. Asked in the technical screen stage. Basic SQL exercise.

One row per region and product_category, plus an overall total row.
Return region, product_category, order_count, total_revenue, and avg_order_value.
Include only completed orders.
Sort with the overall total row last, then by region, then product_category.

orders

Your question is CTEs and Data Granularity. 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.