0 votes
in Information Technology by (15 points)
edited by

a) To show all information of students where capacity is more than the number of students in order of Rt no. 

b) To show Area_Covered for busses covering more than 20 km, but charge less than 80000. 

c) To show transporter-wise total no of students travelling. 

d) To show Rt no, Area_covered and average cost per student for all routes where average cost per student is – charges/no of students. 

e) Add a new record with the following data: (11, ‘Moti Bagh’, 35, 32, 10, “Kisan Tours”, 35000) 

f) Give the output considering the original relation as given : 

(i) Select sum(distance) from school where transporter= “Yadav Co.”; 

(ii) Select min(no of students) from school bus; 

(iii) Select avg (charges) from school bus where transporter = “Anand Travels”;

Please log in or register to answer this question.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.