医生doctorid(PK)doctornamePatientpatientid(PK)patientnamedoctoridIhavethefollowingquerytogetthedoctorsdetailswiththenumberofpatientsthathe/sheconsults.assumeapatienthasonlyonedoctortoconsult.selectd.doctorid,d.doctorname,count(p.patientid)fromdoctordinnerjoinpatientpond.doctorid=p.doctoridgroupbyp