InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Please give me the answer of this question |
| Answer» HELLO EVERYONEYOUR ANSWER IS GIVEN BELOW :(i) Select from School BUS where capacity>No.of students order by Rtno;(ii) Select Area_covered from School Bus where DISTANCE>20km and charges <80000;(iii) Select no. of students from School Bus order by Transporter;(iv) Select Rto, Area_covered, average cost per student from School Bus where average cost per student = charges/no.of students;(v) Insert into School Bus Values(11, "Motibagh", 35,32,10," Kisan Tours", 35000) ;(vi) (a) SUM(DISTANCE) 50(b) MIN(NO.OF STUDENTS) 40(c) AVG(CHARGES) 81667(d) (DISTINCT TRANDPORTER) Shivam travels Anand travels Bhalla travels Yadav travels Speed travels Kisan tours THANK YOU☺I HOPE IT'S HELPFUL FOR YOU. | |