Count the number of expensive facilities
Question
Produce a count of the number of facilities that have a cost to guests of 10 or more.
Expected Results
| count |
|---|
| 6 |
Your Answer
Your Results
Loading database...
Answers and Discussion
select count(*) from cd.facilities where guestcost >= 10;This one is only a simple modification to the previous question: we need to weed out the inexpensive facilities. This is easy to do using a WHERE clause. Our aggregation can now only see the expensive facilities.