Daniel Kiptoo — Verification Report

Score

81/100

Percentile

Top 54%

Integrity confidence

79%

Plagiarism similarity

16%

Code playback

Keystroke timeline · ETL Backfill Recovery (SQL)

42:00 / 42: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;