公司有一个客户的数据表，此表的建立语句如下：CREATE TABLE Customers（CustomerID int NOT NUL

公司有一个客户的数据表，此表的建立语句如下：

CREATE TABLE Customers

(CustomerID int NOT NULL,

CustomerName varchar(50) NOT NULL,

ContactName varchar(30) NULL,

Phone varchar(20) NULL,

Country varchar(30) NOT NULL,

CONSTRAINT PK_Customers PRIMARY KEY(CustomerID)

)

大部分的国家或地区只包含2-3个客户，而一些国家包括多于20个客户。现在公司想对客户数量在10(含10)个以上的国家进行广告宣传，你使用()语句将这些国家列出。

A SELECT Country FROM Customers

GROUP BY Country HAVING COUNT (Country)>=10

B SELECT TOP 10 Country FROM Customers

C SELECT TOP 10 Country FROM Customers

FROM (SELECT DISTINCT Country FROM Customers) AS X

GROUP BY Country HAVING COUNT(*)>= 10

D SET ROWCOUNT 10

SELECT Country, COUNT (*) as “NumCountries”

FROM Customers

GROUP BY Country ORDER BY NumCountries, Desc