SQL-Abfrage für 80% Kunden

[Pikachu]

Probier's mal so oder ähnlich:

How to SELECT top N rows that sum to a certain amount?

select t1.amount
from MyTable t1
left join MyTable t2 on t1.amount > t2.amount
group by t1.amount
having coalesce(sum(t2.amount),0) < 7