Select DatePart(wk,[Time]), SUM(Case When UserScore>=60 Then 1 Else 0 End)*1.0/Count(*) From TableName Group By DatePart(wk,[Time])Select DatePart(wk,[Time]), SUM(Case When UserScore>=60 Then 1 Else 0 End)*1.0/Count(*) From TableName Group By DatePart(qq,[Time])
1 10 100
2 50 100
比如 UserScore>=60 表示通过
现在就是想根据时间段(季或周 ) 统计其 通过率 (通过的/总数%)
DatePart(wk,[Time]),
SUM(Case When UserScore>=60 Then 1 Else 0 End)*1.0/Count(*)
From TableName
Group By DatePart(wk,[Time])Select
DatePart(wk,[Time]),
SUM(Case When UserScore>=60 Then 1 Else 0 End)*1.0/Count(*)
From TableName
Group By DatePart(qq,[Time])