Database/SQL Question HELP ASAP!

Question

1. Use HR Database
2. Write the SQL in Transact SQL

Question: Return all the locations that are in countries with multiple locations. For example, if Canada has 2 locations, then I need to return these 2 locations while if Sweden has only 1 location then you do not need to return that location.

Answer 1

Patrick's is a good answer, but your recordset will include Sweden. This is fine, but your question wants only countries with multiple locations. Not all countries with their location count. To do this, depending on how your tables are designed and their relationships, you will likely need to use a separate select statement inside your Where clause. If I knew more about your DB design, I could easily provide an example.

Answer 2

something like this:

SELECT COUNT(LocationID), Country

FROM Locations

GROUP BY Country;