Sobes.tech
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 | +----+---------+---------------------+ | | | | +----+---------+---------------------+