How to print out the number of records given a condition

Question

I'm creating a SQL database for movies and I want to print out the number of movies that are Sci-Fi in the database.

I have ran this command, but I'm getting an error. Can anyone please points out to what is wrong in the command?

SELECT COUNT Genre FROM Movies WHERE Genre='Sci-Fi'

You should never store comma delimited values in a column. Read up on database normalization. — , Mar 08 '17 at 06:52
You marked an answer correct without even telling us what database you are using -1 — Tim Biegeleisen, Mar 08 '17 at 07:00

score 3 · Accepted Answer · answered Mar 08 '17 at 06:49

count is a function, so you need to call it with an argument list in (). count, specifically, can get a special argument *, which means it will just count all the rows (that pass the filtering):

SELECT COUNT(*) FROM Movies WHERE Genre = 'Sci-Fi'
-- Here ----^

Additionally, since you genre column doesn't contain single values (a decision you may want to revisit), using the = operator like this will miss any movie that has multiple genres. Using like should do the trick:

SELECT COUNT(*) FROM Movies WHERE Genre LIKE '%Sci-Fi%'

Thanks for the explanation, much appreciated – Ahmed Al Abdulaal Mar 08 '17 at 07:01 — Ahmed Al Abdulaal, Mar 08 '17 at 07:01

Mohammad · Answer 2 · 2017-03-08T06:59:38.703

0

SELECT COUNT(Title) FROM Movies WHERE Genre like '%Sci-Fi%'

edited Mar 08 '17 at 06:59

answered Mar 08 '17 at 06:48

Mohammad

132
5

1

You answer is partial, you will miss records such as MoveiID=8 – ehh Mar 08 '17 at 06:55
While this code may answer the question, providing additional context regarding how and/or why it solves the problem would improve the answer's long-term value. – Donald Duck Mar 08 '17 at 11:24

score 0 · Answer 3 · answered Mar 08 '17 at 06:49

0

Use below query

select count(*) from movies where Genre like "%Sci-Fi%"

answered Mar 08 '17 at 06:49

Abhishek Gurjar

7,426
10
37
45

Vikram Singh · Answer 4 · 2017-03-08T06:57:09.407

-1

SELECT COUNT(*) FROM Movies WHERE Genre like '%Sci-Fi%'

edited Mar 08 '17 at 06:57

answered Mar 08 '17 at 06:48

Vikram Singh

924
1
9
23

score -2 · Answer 5 · answered Mar 08 '17 at 06:49

-2

Try this one: SELECT COUNT(*) FROM Movies WHERE Genre like 'Sci-Fi'

answered Mar 08 '17 at 06:49

Kula

25
6

How to print out the number of records given a condition

5 Answers5