| 1 | create view ItemFlightDetails (FlightId, FlightNumber, Origin, Destination, ItemId, Name,
|
|---|
| 2 | Description, Price, Brand, Sold, Revenue) as
|
|---|
| 3 | select flight.id, flight.flightnumber, departureAirport.code,
|
|---|
| 4 | arrivalAirport.code, item.id,item.name, item.description, item.price,
|
|---|
| 5 | item.brand, itemssold.quantity, itemssold.quantity * item.price
|
|---|
| 6 | from flight
|
|---|
| 7 | join itemssold on flight.id = itemssold.flightid
|
|---|
| 8 | join item on itemssold.itemid = item.id
|
|---|
| 9 | join gate as departureGate on departureGate.id = flight.actualgatedepartureid
|
|---|
| 10 | join gate as arrivalGate on arrivalGate.id = flight.actualgatearrivalid
|
|---|
| 11 | join terminal as departureTerminal on departureTerminal.id = departureGate.terminalid
|
|---|
| 12 | join terminal as arrivalTerminal on arrivalTerminal.id = arrivalGate.terminalid
|
|---|
| 13 | join airport as departureAirport on departureAirport.id = departureTerminal.airportid
|
|---|
| 14 | join airport as arrivalAirport on arrivalAirport.id = arrivalTerminal.airportid;
|
|---|
| 15 |
|
|---|
