-- 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.