Njeri Mwangi — Verification Report

Score

88/100

Percentile

Top 29%

Integrity confidence

89%

Plagiarism similarity

10%

Code playback

Keystroke timeline · Regional Cohort Aggregation (SQL)

41:00 / 41:00

SELECT c.country,
       COUNT(*) FILTER (WHERE a.score >= 70) AS passed,
       ROUND(AVG(a.score), 1) AS avg_score
FROM candidates c
JOIN assessments a ON a.candidate_id = c.id
WHERE a.completed_at > NOW() - INTERVAL '90 days'
GROUP BY c.country
ORDER BY avg_score DESC;

Integrity event timeline

Final submission

SELECT c.country,
       COUNT(*) FILTER (WHERE a.score >= 70) AS passed,
       ROUND(AVG(a.score), 1) AS avg_score
FROM candidates c
JOIN assessments a ON a.candidate_id = c.id
WHERE a.completed_at > NOW() - INTERVAL '90 days'
GROUP BY c.country
ORDER BY avg_score DESC;