Question

please give me the answer of this question​

Answer 1

Answer:

HELLO EVERYONE

YOUR 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.