List the number of requested clinical tests and the average unit cost of these tests, per diagnosis. Order the list in descending order of diagnosis and then the number of requested clinical tests.

 

Transcribed Image Text:

Clinical Tests TestID 1 со Name RequestedClinical Tests ConsultationID TestID ∞ Description UnitCost 8 Physician FirstName LastName ID Specialty Phone Salary Date Result 1 Medication ConsultationID Medication ID Dosage DosageUnit Quantity UnitCost 1 Medicine MedicationID Name Indications Contraindications Consultation ConsultationID PhysicianID PatientSSN Date ∞ 1 Patient SSN со ∞ FollowUp ConsultationID Item Diagnosis Treatment FirstName LastName InsuranceNo DOB Clinical Tests TestID 1 со Name RequestedClinical Tests ConsultationID TestID ∞ Description UnitCost 8 Physician FirstName LastName ID Specialty Phone Salary Date Result 1 Medication ConsultationID Medication ID Dosage DosageUnit Quantity UnitCost 1 Medicine MedicationID Name Indications Contraindications Consultation ConsultationID PhysicianID PatientSSN Date ∞ 1 Patient SSN со ∞ FollowUp ConsultationID Item Diagnosis Treatment FirstName LastName InsuranceNo DOB

Answer rating: 100% (QA)

It appears that youve provided an entityrelationship diagram ERD and a task that requires querying information from a database according to the struct... View the full answer