Witam, czy ktos ma pomysl jak napisac takiego SQL:
http://postimg.org/image/47272oynd/
@Czy da sie to w SQL wgl napisac?
0
0
select recipient as account_name from transfer group by recipient having sum(amount) > 1000
0
podaj maila do prowadzącego, żeby mu bezpośrednio wysłać zadanie
1
np. dla postgresa i mssqla
SELECT
recipient
FROM (
SELECT
ROW_NUMBER() OVER (PARTITION BY recipient ORDER BY ammount desc) AS r,
t.*
FROM
transfers t) x
WHERE
x.r <= 3
group by
recipient
having
sum(ammount) >= 1024