Question: Query 2 ) To validate that maintenance schedules for each drone are adequate and being setup correctly, the maintenance team needs a sample of flights
Query
To validate that maintenance schedules for each drone are adequate and being setup correctly, the maintenance team needs a sample of flights for two of the drones.
For Drone # they are requesting all flights from the year
For Drone # all flights from October through the end of December
Utilize a UNION statement to produce the requested results.
The first query should focus on Drone # and the second query on Drone #
Show all the fields from the FlightReservation table
Hint: use date functions: strftime and julianday
Sort by DroneID, then PickUpTime
Label the query as Query
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
