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>P BUS NO<br>BUS NAME varchara200<br>varchara(20)<br>TOTAL SEATS nunber(11)<br>AVA SEATS number(a1)<br>TYPE<br>dated<br>varchar2(20)t<br>nunber1) NO<br>number(11)<br>DURATION<br>BAYMENTS<br>DISCOUNTS<br>PAYMENT_ID varchar23)<br>varchar23<br>number(11)cescOUNT D<br>PDISCOUNT ID<br>varchar23<br>DISCOUNT AMOUNT nunber(11)<br>TIOET ID<br>ETIOKET ID<br>TICKETS<br>DISCOUNT ID varchar2(3)o<br>PTIOET ID<br>varcha23) DLE D<br>PSOEDULE ID varchar2(3)<br>number(11)<br>number(11)o<br>nunber(11)<br>FARE<br>USER ID<br>OUSER JD<br>NO SEATS<br>USERS<br>PUSER ID nunber(11)<br>varchar2(20)t<br>ADDRESS varchar2(100)t<br>number(11)<br>EMAILID varchar2(30)t<br>primary hey - not wall<br>NAME<br>p fomign key<br>duta type - wuvber<br>a data type date<br>PHNO<br>It data type - vachar?<br>CANCELLATION<br>CANCELLATION_ID varchar23)<br>TIOET ID<br>PBD ID<br>TICKET ID<br>BOOKINGDETAILS<br>varchar23)<br>nunber(11) ID<br>B0_ID nunber(11)<br>ACC_NO number(11<br>NAME varchar2(10) e<br>PUSER ID nunber(11)<br>ERID<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 P BUS NO BUS NAME varchara200 varchara(20) TOTAL SEATS nunber(11) AVA SEATS number(a1) TYPE dated varchar2(20)t nunber1) NO number(11) DURATION BAYMENTS DISCOUNTS PAYMENT_ID varchar23) varchar23 number(11)cescOUNT D PDISCOUNT ID varchar23 DISCOUNT AMOUNT nunber(11) TIOET ID ETIOKET ID TICKETS DISCOUNT ID varchar2(3)o PTIOET ID varcha23) DLE D PSOEDULE ID varchar2(3) number(11) number(11)o nunber(11) FARE USER ID OUSER JD NO SEATS USERS PUSER ID nunber(11) varchar2(20)t ADDRESS varchar2(100)t number(11) EMAILID varchar2(30)t primary hey - not wall NAME p fomign key duta type - wuvber a data type date PHNO It data type - vachar? CANCELLATION CANCELLATION_ID varchar23) TIOET ID PBD ID TICKET ID BOOKINGDETAILS varchar23) nunber(11) ID B0_ID nunber(11) ACC_NO number(11 NAME varchar2(10) e PUSER ID nunber(11) ERID

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here