Help with WHERE clause

[javindran]

Basically, I need to find the department which consists more than 10 staffs as I am stuck.

SELECT dname, sid
FROM dept INNER JOIN staff ON dept.did = staff.did
WHERE ?????? (this is the part where I am stuck)

Any SQL will be helpful.
I will frequently monitor this question to reply to ur answers and questions if u need it.
Thanks in advance.

[r035198x]

You need to use COUNT first to get the total staff then use having as explained by examples here http://www.w3schools.com/sql/sql_having.asp

[javindran]

still stuck, can u give an example on count

[r035198x]

Did you read the link I posted above?