|
8> CREATE TABLE Orders (
9> OrderID int NOT NULL ,
10> CustomerID nchar (5) NULL ,
11> EmployeeID int NULL ,
12> OrderDate datetime NULL ,
13> RequiredDate datetime NULL ,
14> ShippedDate datetime NULL ,
15> ShipVia int NULL ,
16> Freight money NULL DEFAULT (0),
17> ShipName nvarchar (40) NULL ,
18> ShipAddress nvarchar (60) NULL ,
19> ShipCity nvarchar (15) NULL ,
20> ShipRegion nvarchar (15) NULL ,
21> ShipPostalCode nvarchar (10) NULL ,
22> ShipCountry nvarchar (15) NULL
23> )
24> GO
1>
2> SELECT CustomerID, EmployeeID, COUNT(*)
3> FROM Orders
4> WHERE CustomerID BETWEEN 'A' AND 'AO'
5> GROUP BY CustomerID, EmployeeID
6> GO
CustomerID EmployeeID
---------- ----------- -----------
(0 rows affected)
1>
2> drop table orders;
3> GO
1>
|
