Get branch, no of students in a branch, total admission fees with respect to a branch from tblStudent table order by admission fees descending.

YasminRadwan26

Save to bookmark

2022-05-13

460

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,count(FirstName),sum(admission_fee) Admission_fee from tblStudent
group by Branch order by Admission_fee desc

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

total answers (1)