Ana sayfa
/
Teknoloji
/
Q2.3 Select DoctorID AVG(TotalBill) From Bill Group by DoctorlD Order by AVG(TotalBill);

Soru

Q2.3 Select DoctorID AVG(TotalBill)
From Bill
Group by DoctorlD
Order by AVG(TotalBill);

Q2.3 Select DoctorID AVG(TotalBill) From Bill Group by DoctorlD Order by AVG(TotalBill);

Çözüm

4.6267 Voting
avatar
Nilüfer
Usta · 5 yıl öğretmeni
Uzman 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: