Answer for SQL - count

https://365datascience.com/dwqa-answer/answer-for-sql-count/ -

Hi Pui!

Thanks for reaching out!

You are getting a different answer because of the rules set by the MySQL syntax, so to speak. Therefore, there’s not too much logic to look for here – there are rules to learn and stick to.

The first query you have isn’t really complying with the MySQL syntax, because this is not the way to specify a condition. The way to do that is, as you’ve done in the second query, with the help of a WHERE clause.

Hope this helps.
Best,
Martin

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy