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!
the number of unique in the reviews table
To count the number of unique films, you'd need to use DISTINCT with COUNT().
SELECT COUNT(film_id) AS count_film_id
FROM reviews;
Run the query in the console to test your theory!
the number of unique in the reviews table
To count the number of unique films, you'd need to use DISTINCT with COUNT().