How to display the names of customers who had more than 3 - ex orders?

Question

MySQL

There are 2 tables. It is necessary to display the names of customers who had more than 3 orders.

Answer 1

select тк.название
from таблица_клиентов тк
join таблица заказов тз on тк.код_клиента=тз.код_клиента
group by тк.название
having count(тк.название)>3