Soru
Q2.3 Select DoctorID AVG(TotalBill) From Bill Group by DoctorlD Order by AVG(TotalBill);
Çözüm
4.6267 Voting
Nilüfer
Usta · 5 yıl öğretmeniUzman doğrulaması
Cevap
The correct answer is:<br /><br />SELECT DoctorID, AVG(TotalBill)<br />FROM Bill<br />GROUP BY DoctorID<br />ORDER BY AVG(TotalBill);<br /><br />Explanation: This SQL query selects the DoctorID and the average TotalBill from the Bill table, groups the results by DoctorID, and orders the results by the average TotalBill in ascending order.
Derecelendirmek için tıklayın: