Advertisement
Warmachine28

Untitled

Jan 24th, 2022
1,336
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table aviation_details(
  2.     passenger_name varchar(255),
  3.     flight_no int,
  4.     departure_airport varchar(255),
  5.     arrival_airport varchar(255),
  6.     flight_date date,
  7.     reservation_status varchar(255),
  8.     flight_fare int,
  9.     airlines varchar(255)
  10. );
  11. insert into aviation_details values('Harsh Aggarwal',23335,'New Delhi','Bengaluru','2022-01-31','full',5260,'Vistara'),
  12. ('Dhruv Sachdeva',27690,'New Delhi','Mumbai','2022-02-01','vacant',4560,'IndiGo'),
  13. ('Ujjwal Gautam',52609,'Patna','Kanpur','2022-02-19','full',4789,'Spice Jet'),
  14. ('Arjun Rathore',62555,'New Delhi','Hyderabad','2022-03-02','full',5487,'Air India');
  15.  
  16.  
  17. select passenger_name as Passenger_Name, flight_no as Flight_Number from aviation_details;
  18. select flight_no as 'Flight Number', departure_airport as 'Departure Airport',
  19. arrival_airport as 'Arrival Airport', airlines as 'Airline Vendor'
  20. from aviation_details;
  21. select flight_no as 'Flight Number', airlines as 'Airline Vendor', reservation_status as 'Reservation Status' from aviation_details where flight_no=52609;
  22.  
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement