Develop SQL Query Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id BUSES BUS NO number(11) SOEDULE PSOEDULE ID varchara(3...


Develop SQL Query<br>Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id<br>BUSES<br>BUS NO<br>number(11)<br>SOEDULE<br>PSOEDULE ID varchara(3<br>TRAVEL DATE<br>SOURCE<br>DESTINATION varchar2(20) e<br>PBUS NO<br>BUS NAME varchar2(20)<br>varchar2(200<br>TOTAL SEATS nunber(11)<br>AVA SEATS number(a1)<br>TYPE<br>dated<br>varchar2(20)t<br>nunber1) NO<br>nunber(11)<br>DURATION<br>BAYMENTS<br>DISCOUNTS<br>varchara(3<br>PAYMENT_ID varchar2(3)<br>varchar23<br>number(11) cesCOUNT D<br>PDISCOUNT_ID<br>DISCOUNT AMOUNT number(11)<br>TIOET ID<br>TICKET ID<br>TICKETS<br>DISCOUNT ID varchar2(3)<br>varchar23) EDLE D<br>PTIOET ID<br>PSOEDULE ID varchar2(3)<br>number(11)<br>FARE<br>OUSER ID<br>NO SEATS<br>USER JD<br>number(11)o<br>USERS<br>number(11)<br>PUSER ID nunber(11)<br>varchar220) t<br>ADDRESS varchar2(100)t<br>number(11)e<br>EMAILID varchar2(30) t<br>primary hey - not nall<br>NAME<br>e fomign key<br>duta type - wunber<br>d data type date<br>PHNO<br>It| data type - vachar2<br>CANCELLATION<br>CANCELLATION_D varchar23)<br>varchar23)<br>number(11) ID<br>TICKET JD<br>BOOKINGDETAILS<br>TIOET ID<br>80 ID number(11)<br>ACC NO number(11)<br>NAME varchar2(10) t<br>PUSER ID nunber(11)<br>R ID<br>

Extracted text: Develop SQL Query Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id BUSES BUS NO number(11) SOEDULE PSOEDULE ID varchara(3 TRAVEL DATE SOURCE DESTINATION varchar2(20) e PBUS NO BUS NAME varchar2(20) varchar2(200 TOTAL SEATS nunber(11) AVA SEATS number(a1) TYPE dated varchar2(20)t nunber1) NO nunber(11) DURATION BAYMENTS DISCOUNTS varchara(3 PAYMENT_ID varchar2(3) varchar23 number(11) cesCOUNT D PDISCOUNT_ID DISCOUNT AMOUNT number(11) TIOET ID TICKET ID TICKETS DISCOUNT ID varchar2(3) varchar23) EDLE D PTIOET ID PSOEDULE ID varchar2(3) number(11) FARE OUSER ID NO SEATS USER JD number(11)o USERS number(11) PUSER ID nunber(11) varchar220) t ADDRESS varchar2(100)t number(11)e EMAILID varchar2(30) t primary hey - not nall NAME e fomign key duta type - wunber d data type date PHNO It| data type - vachar2 CANCELLATION CANCELLATION_D varchar23) varchar23) number(11) ID TICKET JD BOOKINGDETAILS TIOET ID 80 ID number(11) ACC NO number(11) NAME varchar2(10) t PUSER ID nunber(11) R ID

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here