this what i am getting the output of a query
North | 46738.0 | 1488420.0 | 47589.0
East | 48325.0 | 1487170.0 | 46971.0
West | 48397.0 | 1493430.0 | 48033.0
South | 47726.0 | 1483620.0 | 48787.0
Central | 47746.0 | 1484860.0 | 47260.0
now i need to display a row at the last of the output
city yday mtd target
North | 46738.0 | 1488420.0 | 47589.0
East | 48325.0 | 1487170.0 | 46971.0
West | 48397.0 | 1493430.0 | 48033.0
South | 47726.0 | 1483620.0 | 48787.0
Central | 47746.0 | 1484860.0 | 47260.0
Total | 238932.0 | 7437500.0 | 238640.0
the total of yday is sum of the north,east,west,south,central - Yday
how can i do it by query