Get branch wise average admission fees from “tblStudent” table order by admission fees ascending order.

YasminRadwan26

Save to bookmark

2022-05-13

478

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,

YasminRadwan26

2022-05-13

need an explanation for this answer? contact us directly to get an explanation for this answer

Select Branch, AVG(admission_fee) as Average_admission_fees from tblStudent
group by Branch order by SUM(admission_fee) ASC

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)