Hard
LEFT JOIN
Pro Challenge

Customer Orders After 2024-03-01

Count each customer's orders placed on or after 2024-03-01. 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-01. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.

Difficulty
Advanced
SQL concept
LEFT JOIN