Customer Orders After 2024-03-12

Count each customer's orders placed on or after 2024-03-12. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Count each customer's orders placed on or after 2024-03-12. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.

Difficulty: Advanced
SQL concept: LEFT JOIN