Write an SQL query to display:

The Flight details with their manufacturer under 'Emirates' and 'Cathay Pacific Airline.

Your output should contain columns as given below.

FLIGHT$\_$ID

AIRPLANE$\_$ID

DEPARTURE$\_$DATE

DEPARTURE$\_$TIME

ARRIVAL$\_$DATE

ARRIVAL$\_$TIME

FLIGHT$\_$FROM

FLIGHT$\_$

FIRST AMELAST AEcONTACTDESIONATIONPILOT LCENSEeabinerewABINCREW DPLIOHT IDFIRST A MELAST NAMEcONTACTboardlnopesDEC I$1$AL$(90,$ D$)$DECHALEBD$,$ OLVARCHARCBO$)$VARCHARBO$)$VARCHAR$($BO$)$VARCHAR$($BOYVARCHAR$($BO$)$FLIGHT IDPASSENGER$\_$IDGATEBAGGAGEALFtnblelDECIMALIB$0,$ ODECIMAL$(90,$VARCHAR$($BO$)$VARCHA R$(90)$VARCHARIBO$)$TublejBOA RDNGPM Ss D DECIMALIS$0.0)$DECIMALBo$.$ oDECIMALCB$00)$DECIMAL$(9$D$,0)$DECIMALB$0,$ o$)$VARCHAR$($BO$)$es binerew Bn $1$boerdingns$\_$ibfkbo ardingpess bfk$2$ightFLIGHT IDAIRPLANE$\_$IDDEPA RTURE DATEDEPA RTURE TIMEARAINAL DATEARRIVAL$\_$TIMEFLIGHT FROMFLIGHT TOpassengerPASSENGER IDFIRST NAMEAST NAMEEMAILCONTACTDECIMAL$(30,0)$DECIMALI$30,0$VARCHARSO$)$VARCHARBO$)$VARCHAR$($BO$)$VARCHAR$801$VARCHAR$($O$)$VARCHAR$(8$O$)$Ita bleDECIMALB$0,0$VARCHAR$($B$0)$VA RCHARIBO$)$VARCHAR$($BOVA RCHAR$($B$0)$Aight ibneARPANEAIRLINEELNIMBEMANUEACTUREROECIMALI$30,$oOECMALN$6$ oyanaMARCHAR$($HOYVARCHARB$0$YAMLANEMAMADORESScoNTACYMAIDE CIMAU$30.01$VARCHAR$($HOSVARCMAR$($a$01$VARCHAR$($BOYVARCHAR$($aO$)$VIABCHAR$($o$)$TO

MANUFACTURER

You can view the database schema by clicking the View Schema tab at the bottom of the query window on the right$-$hand side of the screen.