Question

Produce a count of the number of facilities that have a cost to guests of 10 or more.
Schema reminder
DB schema

Expected Results

count
6

Your Answer Hint Help Save Run Query

 

Answers and Discussion Show

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.

You'll need to add a WHERE clause to the answer of the previous question.

Keyboard shortcuts:


Other hints: