Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- day
- ,SUM(Profit)
- FROM
- (
- Select
- t1.day
- ,t2.Profit
- FROM f_daily_sales t1
- JOIN f_daily_sales t2
- On t1.food_truck_id = t2.food_truck_id
- AND t1.day >=t2.day
- ) t3
- Group by day
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement