Learn $/$ Courses $/$ Intermediate SQL

Exercise

Learning to COUNT$()$

You saw how to use COUNT$()$ in the video. Do you remember what it returns?

Here is a query counting film$\_$id$.$ Select the answer below that correctly describes what the query will return.

SELECT COUNT$($film$\_$id$)$ AS count$\_$film$\_$id FROM reviews;

Run the query in the console to test your theory!

$($v$)$ Instructions

Learn $/$ Courses $/$ Intermediate SQL

Exercise

query.sql

Instructions $3/4$

$25xP$

$3$ Calculate the lowest gross nim in $19y4$ and use the alias lowest$\_$gross $.$