Hi, why does the first code work too, but gives me a different outcome? thanks...

Hi Kfir! Thanks for reaching out. Both codes work because they have correct syntax. The difference is because in the second one you have a filter -the WHERE clause. The first one does not have a filter. This condition in the COUNT() function is neglected by the Workbench. These codes are the same: COUNT(salary>=100000) and COUNT(salary). Hope this helps. Best, Tsvetelin

Follow this topic