How to organize a complex query?

Question

MySQL

There are 2 tables clients and orders, you need to make a query that will display the name and id of the client, whose number of applications is more than 3. The difficulty is that in orders each order has an id_clients field and these id_clients are repeated, you must first calculate how many repeated id_clients and display only those who have more than 3 repetitions.

Answer 1

More or less like this

SELECT c.id, c.name FROM orders AS o INNER JOIN clients c ON o.id_client=c.id GROUP BY o.id_client HAVING count(o.id_client) > 3

Answer 2

SELECT clients.name,clients.id FROM clients WHERE (SELECT COUNT(*) FROM orders WHERE orders.id_client = clients.id) >3