Carter 已修改 . 還原成這個修訂版本
1 file changed, 15 insertions
check.sql(檔案已創建)
| @@ -0,0 +1,15 @@ | |||
| 1 | + | SELECT count(*), | |
| 2 | + | CASE | |
| 3 | + | WHEN gp.PublishedAt IS NOT NULL THEN 2 | |
| 4 | + | WHEN gp.LastActivityAt > gp.CreatedAt or cv.UpdatedAt > cv.CreatedAt THEN 1 | |
| 5 | + | ELSE 0 | |
| 6 | + | END AS GrowthPlanState | |
| 7 | + | FROM Growth.develop.GrowthPlan gp | |
| 8 | + | JOIN Growth.ec.[User] u ON u.Id = gp.OwnerId | |
| 9 | + | JOIN Analytics.survey.Users au ON au.MembershipId = u.Id | |
| 10 | + | JOIN Growth.develop.CareerVision cv on cv.UserId = u.Id | |
| 11 | + | WHERE u.OrganizationId = 166369 group by CASE | |
| 12 | + | WHEN gp.PublishedAt IS NOT NULL THEN 2 | |
| 13 | + | WHEN gp.LastActivityAt > gp.CreatedAt or cv.UpdatedAt > cv.CreatedAt THEN 1 | |
| 14 | + | ELSE 0 | |
| 15 | + | END | |
上一頁
下一頁