SQL task: list clients whose average payment amount is greater than 2000

To solve the task, you need to group payments by clients, calculate the average payment amount for each client, and filter those with an average greater than 2000.

Example SQL query:

SELECT client_id
FROM payments
GROUP BY client_id
HAVING AVG(amount) > 2000;

Here:

• payments is the table with payments, which has fields client_id and amount.
• GROUP BY client_id groups records by clients.
• HAVING AVG(amount) > 2000 filters groups where the average payment amount is greater than 2000.

If you need to display not only the ID but also other client data, you can perform a JOIN with the clients table.