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 2)
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 #1 they are requesting all flights from the 2022 year
For Drone #10 all flights from October 2022 through the end of December 2022.
Utilize a UNION statement to produce the requested results.
The first query should focus on Drone #1, and the second query on Drone #10
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 3
 Query 2) To validate that maintenance schedules for each drone are

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 Databases Questions!