Celestial Airlines prides itself on providing smooth and efficient travel experiences
for passengers across the country. The airline maintains a comprehensive flight record
database, capturing flight ID, origin, destination, seat capacity, and booked seats for each
flight. The Airline Operations Analyst is tasked with monitoring flight occupancy to optimize
bookings, identify flights with available seats, calculate the total number of passengers across
all flights, and sort flights by capacity for planning future schedules. Your role is to provide SQL
queries to assist airline operations.

Question - 1

List all flights with available seats

Question - 2

Calculate total passengers booked across all flights.