2. List the name and the state of all United States airports. 3. List the name and the fleet size of all carriers employing more than 50000 workers.
Relational Algebra Questions:
Using the instance of the Airport
algebra:
1. List full details of all airports located outside the United States.
Note: You should use the not equal sign in this query.
2. List the name and the state of all United States airports.
3. List the name and the fleet size of all carriers employing more than 50000 workers.
4. List the carrier name, the carrierID, the flightNo and the date of all flights.
5. Display the number of airports.
6. Display the number of flights with distances longer than 3000 miles.
7. Display the number of all carriers and the average of their revenues.
8. Display the number of flights leaving from JFK and the total of their distances.
9. Display the minimum, the average, and the maximum distances of the flights that are
scheduled on October 17th, 2017?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
