check.sql
· 729 B · MySQL
Brut
SELECT count(*),
CASE
WHEN gp.PublishedAt IS NOT NULL THEN 2
WHEN gp.LastActivityAt > gp.CreatedAt or cv.UpdatedAt > cv.CreatedAt THEN 1
ELSE 0
END AS GrowthPlanState
FROM Growth.develop.GrowthPlan gp
JOIN Growth.ec.[User] u ON u.Id = gp.OwnerId
JOIN Analytics.survey.Users au ON au.MembershipId = u.Id
JOIN Growth.develop.CareerVision cv on cv.UserId = u.Id
WHERE u.OrganizationId = 166369 group by CASE
WHEN gp.PublishedAt IS NOT NULL THEN 2
WHEN gp.LastActivityAt > gp.CreatedAt or cv.UpdatedAt > cv.CreatedAt THEN 1
ELSE 0
END
| 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 |