Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write an SQL query to display The details of cabin crew whose first name start with ' I ' or ' J ' Your output
Write an SQL query to display
The details of cabin crew whose first name start with I or J
Your output should have columns as given below. CrewId
FirstName
LastName
Contact
You can view the database schema by clicking the View Schema tab at the bottom the query window on the righthand side of the screen.
epbincrenlotPILOT IDFLIGHT DFIRST NA MELAST NA MECONTA CTDESIGNATIONPILOT LUCENSEFLIGHT IDFIRST NA MEGABINCREW DUAST NAMEcONTACTbo ardingpassBOARDINGPASS IDGATEFUGHT IDPASSENGER IDMEALBAGGAGEItablelDECIALDEC IMALBO, OVARCHARBOVARCHARBOVARCHAABOVARCHARIBOVARCHARBOTtebleDECIMAL DDECINAL OVARCHA RBVARCHA RVARCHARSOtableDECIMALI ODECIMALDECIMALBDECIMALEDECINALB OVARCHARpilot ibfCabincrew ibrk boerding pa ss bfkbo ardingpa so jbfkAightFLIGHT IDAIRPLANE IDDEPA RTURE DATEDEPA RTURETIMEARRIVAL DATEARRIVAL TIMEFLIGHT FROMFLIGHT TOpassengerPASSENGERDFIRST MAMELAST NAMECONTACTTtableDECIMALBDECIMALIo aVARCHARBVARCHROVARCHARVARCHARVARCHAR OVARCHARIODECIMALIMARCHARBVAACHARIBOVAHCHAAIBDVA RCHARIBMig ht ibfk alrplanetablelAIRPUANE IDDECIMALIBO OAIALUNE ID DECIMALao. oyMMO DELNUMBER VARCHARBOairplane ibfkariineAIRLNE IDNAMELOGOADORESscONTACTEMAILtableDECIMAuVARCHARSOVARCHARSOVARCHARSOVARCHA RBOVARCHARBOMANUFACTURER VARCHARBD
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started