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
SELECT clients.name,clients.id FROM clients WHERE (SELECT COUNT(*) FROM orders WHERE orders.id_client = clients.id) >3