The HR department needs a list of countries that have no departments located in them. Display the country ID and the name of the countries. Use set operators to create this report
نرجو حل هذا السؤال المهم من أخصائى السيكول
SELECT CountryID,CountryName FROM Countries WHERE CountryID NOT IN (SELECT CountryID FROM Departments GROUP BY CountryID);
Microsoft Certified DataBase Administrator MCDBA
السلام عليكم مشكور عالرد بس السؤال عاوز يستخدم set operators