Scenario SQL Question
Weekend vs Weekday Revenue Split
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
Compare order volume and revenue between weekends (Sat/Sun) and weekdays. Return day_type ('Weekend' or 'Weekday'), order_count, total_revenue, avg_order_value — ordered by total_revenue DESC.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: