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 # or Plane #
SELECT pilotNum
FROM PilotLog
GROUP BY pilotNum
HAVING planeNum or
SELECT pilotNum
FROM PilotLog
WHERE planeNum OR planeNum
SELECT pilotNum
FROM PilotLog
HAVING planeNum ANY
SELECT pilotNum, planeNum
FROM PilotLog
WHERE planeNum AND planeNum
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
