Different query, same result

Question

Hello,

I came up with the following query before checking the attached solution. The results are the same. Is there anything wrong with my query or is this just another way to get the same result?

SELECT 
    e.gender, COUNT(e.gender) AS quantity
FROM
    employees e
        JOIN
    titles t ON e.emp_no = t.emp_no
WHERE t.title = 'Manager'
GROUP BY e.gender
;

Answer 1

Hi Zach!
Thanks for reaching out.

This is also a valid solution. Bravo!

Hope this helps.
Best,
Tsvetelin

Answer 2

If I am not wrong, this is how the sql statements are written using the MS SQL. But whey when you you use the Oracle SQL, you don't have to specify the "JOIN" reserved word to indiacate a JOIN between columns of tow different tables, just an " = " sign in the WHERE Clause will do.

Different query, same result

Submit an answer

related questions