PostgreSQL Exercises

Previous Exercise

Next Exercise

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.
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.

            

          

        

      

      
      

        
Previous Exercise

        

          
        

        
Next Exercise

      

    

      

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

      

        

	  
Keyboard shortcuts:

	  
	  

	  
Other hints: