[SQL] Max QTY with price <= 100 (Query)

Name Price Qty
A 3 30
B 5 3
C 5 3
D 6 20

i have a table contain data like this. i want to get what is the maximum of sum(qty) that i can provide Price <= 100

expected output : 32 coming from : 30 qty A and 2 qty from B or C

Continue reading...