difficult mysql question

[xiaodao]

table structure

C1 ID C2
D1 ID1 10
D2 ID2 6
D3 ID3 14
D4 ID4 5


first i want sort the table according to c1, then i want to add c2 up, then find out the id which when added to sum >=200

can everything combine in one query thanks

[guelphdad]

so what have you tried so far? note that your sorting should be done last.

[xiaodao]

i still cannot solve the problem

[guelphdad]

without posting something you have tried it is unlikely you will get an answer posted for you.