Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT BUSES number(11) BUS_NAME varchar2(20) t varchar2(20) t TOTAL SEATS number(11) # AVAIL SEATS number(11) # P...

Databse SQL

Extracted text: Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT BUSES number(11) BUS_NAME varchar2(20) t varchar2(20) t TOTAL SEATS number(11) # AVAIL SEATS number(11) # P BUS_NO SCHEDULE SCHEDULE_ID TRAVEL DATE varchar2(3) date d varchar2(20) t DESTINATION varchar2(20)t TYPE SOURCE number(11) NO number(11) # O BUS_NO DURATION PAYMENTS DISCOUNTS DISCOUNT_ID DISCOUNT_AMOUNT number(11) # varchar2(3) P PAYMENT_ID varchar2(3) t varchar2(3) number(11) O DISCOUNT_ID varchar2(3) TICKET ID BD IDS O TICKET_ID FoO BD_ID TICKETS DISCOUNT_ID TICKET ID varchar2(3) CHEDULE ID O SCHEDULE_ID varchar2(3)O number(11) # USER ID number(11) O number(11) # FARE PUSER ID NO SEATS USERS number(11) varchar2(20) t ADDRESS varchar2(100) t number(11) # EMAILID varchar2(30) t USER ID P primary key - not null NAME foreign key PHNO # data type - number d data type - date CANCELLATION It| data type - varchar2 CANCELLATION_ID varchar2(3) t O TICKET_ID O BD_ID TICKET ID BOOKINGDETAILS varchar2(3) number(11) ID BD_ID number(11) ACC_NO number(11) # NAME varchar2(10) t PUSER_ID number(11) USER_ID