SHOW SQL CODE WITH OUTPUT

Question 12: 1. Consider the following table: Column Name BusNo Origin Destination Rate Kilometer Start time Datatype NUMERIC VARCHAR VARCHAR DECIMAL NUMERIC NUMERIC Size 4 10 10 Constraint Primary Key NOTNULL NOTNULL NOTNULL CHECK for >200 5,2 5 2.2 a) Write a SQL command to create the above table and insert suitable data. b) Find out the bus no which has the same destination like other bus but rate is greater than the other. c) Create a view bus consisting of busno, origin, destination, start_time of buses with destination as Agra