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