67 154
Assignments Done
99,4%
Successfully Done
In November 2018

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

Question #60529
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
Expert's answer
Admissions with ID greater than 100, cost greater than 50 per service, and total cost per admission greater than 200

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions