If this is a valid SQL syntax, what does it do?

[Admin]

I mistakenly came out with this query:

SELECT DISTINCT COUNT (business_id)
FROM hours

The above did come out with result, which is count of all the business-ids of the table. I understand it should then be a valid syntax. Any explanation will be helpful, especially how it is different from the below query.

My query should have been:

SELECT COUNT (DISTINCT business_id)
FROM hours

---

Reply

---

If this is a valid SQL syntaxt, what does it do?

[Author]

Posts