this is 2000 and its not homework.the first table is a sales table which gets updated w when a sale happnes.to arrive at the sale for a specific date I have to get the difference from previous date.

also these were created,triggers wrote before.i will not be able to modifiy them