create table aviation_details(
    passenger_name varchar(255),
    flight_no int,
    departure_airport varchar(255),
    arrival_airport varchar(255),
    flight_date date,
    reservation_status varchar(255),
    flight_fare int,
    airlines varchar(255)
);
insert into aviation_details values('Harsh Aggarwal',23335,'New Delhi','Bengaluru','2022-01-31','full',5260,'Vistara'),
('Dhruv Sachdeva',27690,'New Delhi','Mumbai','2022-02-01','vacant',4560,'IndiGo'),
('Ujjwal Gautam',52609,'Patna','Kanpur','2022-02-19','full',4789,'Spice Jet'),
('Arjun Rathore',62555,'New Delhi','Hyderabad','2022-03-02','full',5487,'Air India');


select passenger_name as Passenger_Name, flight_no as Flight_Number from aviation_details;
select flight_no as 'Flight Number', departure_airport as 'Departure Airport',
arrival_airport as 'Arrival Airport', airlines as 'Airline Vendor'
from aviation_details;
select flight_no as 'Flight Number', airlines as 'Airline Vendor', reservation_status as 'Reservation Status' from aviation_details where flight_no=52609;