| 1 | create materialized view TicketRevenueDetails (FLightId, FLightNumber, FlightCapacity, TicketsSold,
|
|---|
| 2 | TicketBasePriceTotal, TicketFinalPriceTotal) as
|
|---|
| 3 | select flight.id, flight.flightnumber, airplanemodel.numberofseats,
|
|---|
| 4 | count(ticket.id), sum(ticket.baseprice), sum(ticket.finalprice)
|
|---|
| 5 | from flight
|
|---|
| 6 | join ticket on flight.id = ticket.flightid
|
|---|
| 7 | join airplane on flight.airplaneid = airplane.id
|
|---|
| 8 | join airplanemodel on airplane.modelid = airplanemodel.id
|
|---|
| 9 | group by flight.id, flight.flightnumber, airplanemodel.numberofseats;
|
|---|
| 10 |
|
|---|
