Hi: I had posted an ER diagram (see the attachment file er.jpg). In the diagram, there is a weak entity VISITS which is on the right side of...
Thanks. It still does not work. The value of COUNT(*) for department 2 should be 0. But it is 1 in results. Can you fix this error? The followings...
It does not work. The deparment 2 still not show up in the results.
I have a problem which is "For each department, find the department number and the number of employees of the department. It does not matter...
Separate names with a comma.