```
SELECT f.flight_id,
       COUNT(b.Booking_ID) As "Total SeatPurchased",
       COUNT(b.Booking_ID)*flight_price 
FROM   booking b , flight f
WHERE  b.flight_id=f.flight_id 
GROUP BY f.flight_id,f.flight_price
ORDER BY COUNT(b.booking_id) desc;

```

How do I compute the grand total for this sql? I want to calculate all the flightPrice and at the end of the whole thing. I want to sum up all as the grand total.

Sample Output:

```
FLIGHT_ID  Total Seat Purchased  COUNT(B.BOOKING_ID)*FLIGHT_PRICE 
-----------------------------------------------------------------
F0006                       149                            11771                
F0011                       148                            38332                
F0012                       131                            11528                
F0003                       130                            33670                
F0010                       115                            10120                
F0004                       113                             8362                
F0005                       108                             7992                
F0007                       101                             7373                
F0015                        80                            11200                
F0002                        50                             5700                
F0008                        41                             8774                
F0013                        36                             8316                
F0001                        35                             6265                
F0014                        35                             7490                
F0009                        35                             4690  
                                               Grandtotal:xxxxxx  

```