Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Customers (
client int,
payment int
);

INSERT INTO Customers(client, payment) VALUES
(1, 1000),
(1, 7000),
(1, 6000),
(1, 50000),
(1, 5500),
(1, 5600),
(2, 1000),
(2, 1000);

CREATE TABLE



INSERT 0 8


select
  client,
  count(*) filter(where payment > 5000) as large_payment_count,
  avg(payment) as average_payment
from Customers
group by client


client
large_payment_count
average_payment


2
0
1000.0000000000000000

1
5
12516.666666666667



SELECT 2


INSERT INTO Customers(client, payment) VALUES
(1, 6000);

INSERT 0 1


select
  client,
  count(*) filter(where payment > 5000) as large_payment_count,
  avg(payment) as average_payment
from Customers
group by client
having count(payment) filter(where payment > 5000) > 5
   and avg(payment) > 10000


client
large_payment_count
average_payment


1
6
11585.714285714286



SELECT 1