❓ Help PHC Bot

[inoako1]

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 query will return the count of the number of rows in the "reviews" table, specifically counting the occurrences of the "film_id" column.

To run the query in the console, you can use the following steps:
1. Open the console or terminal.
2. Connect to the database where the "reviews" table is located.
3. Execute the query: SELECT COUNT(film_id) AS count_film_id FROM reviews;
4. The console will display the result, which will be a single value representing the count of film_ids in the "reviews" table.

 

[inoako1]

To count the number of unique films, you'd need to use DISTINCT with COUNT().

The query will return the count of the number of rows in the "reviews" table, specifically counting the occurrences of the "film_id" column.

To run the query in the console, you can use the following steps:
1. Open the console or terminal.
2. Connect to the database where the "reviews" table is located.
3. Execute the query: SELECT COUNT(film_id) AS count_film_id FROM reviews;
4. The console will display the result, which will be a single value representing the count of film_ids in the "reviews" table.

To count the number of unique films, you'd need to use DISTINCT with COUNT().