Junior — Senior
Get a list of users with more than five orders
livecode
Task condition
Write an SQL query that, using the tables users and orders:
- identifies all customers with more than five orders;
- returns their name and the number of orders.
users +----+------+ | id | name | +----+------+ | | | +----+------+
orders +----+---------+---------------------+ | id | user_id | order_date | +----+---------+---------------------+ | | | | +----+---------+---------------------+