[编号]
int,[名字]
varchar(10),[评价]int);INSERT INTO #test1 VALUES(1,'AA',2);INSERT INTO #test1 VALUES(2,'BB',2);INSERT INTO #test1 VALUES(3,'AA',3);INSERT INTO #test1 VALUES(4,'AA',1);goSELECT[名字]AS[姓名],COUNT(*)AS[服务次数],SUM(CASE WHEN [评价] = 3 THEN 1 ELSE 0 END) AS [好评],SUM(CASE WHEN [评...
|