Answer to Question #60529 in Databases | SQL | Oracle | MS Access for Sara

Question

What does this query mean?

SELECT admissionID, sum(cost)
FROM services
WHERE admissionID > 100 and cost > 50
GROUP BY admissionID
HAVING sum(cost) > 200

A. Admissions with ID greater than 100, cost greater than 50 per service, and total cost per admission greater than 200

B. First 100 admissions with cost greater than 50 and total cost per patient greater than 200

C. Admissions with ID greater than 100, cost greater than 50 per admission, and total cost per patient greater than 200

D. Admissions with ID greater than 100, and total cost higher than 200 for services with individual costs greater than 50

Answer 1

Admissions with ID greater than 100, cost greater than 50 per service, and total cost per admission greater than 200