SQLite SUM() between several rows

Question

I need some help with the SUM feature in android app. I have a table that looks something like the following :

I have need to SUM Quantities between last two records Notes and last one record with Note. I need to sum Quantity of rows 31,32 and 33. It would return 90. I've tried

SELECT Sum(QUANTITY) FROM fuel_table WHERE NOTE!='' ORDER BY ID DESC

but it returns SUM of all quantities with note.

Answer 1

I am inclined to phrase the question as: sum the quantity from all rows that have one note "ahead" of them. This suggests:

select sum(quantity)
from (select ft.*,
             (select count(*)
              from fuel_table ft2
              where ft2.note = 'Yes' and ft2.id >= ft.id
             ) as numNotesAhead
      from fuel_table ft
     ) ft
where numNotesAhead = 1;