How to create an SQL query that displays the surnames, first names, patronymics of customers who received a loan above average?

Question

SQL

SELECT Clients.Credit, Clients.Last Name, Clients.First Name, Clients.Patronymic
FROM Clients
GROUP BY Clients.Credit, Clients.Client_ID
HAVING (((Clients.Credit)>Avg([Clients]![Credit])));

I do this and it doesn't output anything.

in the table, the average loan is 12k, and so it varies from 1k to 2 million. only 10 people and you need to withdraw, in fact, only those people who took a loan from 12k and above

Answer 1

Subquery (if the DBMS can do so)

SELECT ...
  FROM Клиенты
 WHERE Клиенты.Кредит > (
   SELECT Avg(Клиенты.Кредит) FROM Клиенты
 );