Sobes.tech
Intern — Senior

Counting the number of orders placed by each client

livecode

Task condition

There are two tables: Customers with columns ID and Name, and Orders with columns ID and Customer_ID. Write an SQL query that for each customer shows their name (Name) and the number of records in Orders associated with that customer.