Travego

-- Creating the schema and required tables using MySQLworkbench 
-- Create a schema named Travego and create the tables mentioned above with the mentioned column names. 
-- Also, declare the relevant datatypes for each feature/column in the dataset

-- A. How many female passengers traveled a minimum distance of 600 KMs? (1 mark)

-- B. Write a query to display the passenger details whose travel distance is greater than 500 and who are traveling in a sleeper bus.
-- C. Select passenger names whose names start with the character 'S'.
-- D. Calculate the price charged for each passenger, displaying the Passenger name, Boarding City, Destination City, Bus type, and Price in the output. (3 marks)**/
-- E. What are the passenger name(s) and the ticket price for those who traveled 1000 KMs Sitting in a bus?
-- F What will be the Sitting and Sleeper bus charge for Pallavi to travel from Bangalore to Panaji?
-- G. Alter the column category with the value "Non-AC" where the Bus_Type is sleeper
-- H. Delete an entry from the table where the passenger name is Piyush and commit this change in the database.
-- I. Truncate the table passenger and comment on the number of rows in the table (explain if required).
-- J. Delete the table passenger from the database.