Question: Consider the following table PILOTLOG. Which SQL statement below will return the pilot number of pilots who have flown Plaine # 1 1 0 or

Consider the following table PILOTLOG. Which SQL statement below will return the pilot number of pilots who have flown Plaine # 110 or Plane # 221?
SELECT pilotNum
FROM PilotLog
GROUP BY pilotNum
HAVING planeNum =110 or 221.
SELECT pilotNum
FROM PilotLog
WHERE planeNum =110 OR planeNum =221,
SELECT pilotNum
FROM PilotLog
HAVING planeNum = ANY (110,221)
SELECT pilotNum, planeNum
FROM PilotLog
WHERE planeNum =110 AND planeNum =221
 Consider the following table PILOTLOG. Which SQL statement below will return

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!