Skip to content

Instantly share code, notes, and snippets.

@verma

verma/gist:4245558

Created December 9, 2012 15:19
Show Gist options
  • Save verma/4245558 to your computer and use it in GitHub Desktop.
Save verma/4245558 to your computer and use it in GitHub Desktop.
Download ZIP
Find all agents who have an average score above a certain threshold.
Raw
gistfile1.sql
SELECT SUM(IF(average_score>65,1,0)) AS above_threshold, COUNT(*) AS total FROM
( SELECT agent_id, AVG(score) AS average_score
FROM recordings
JOIN evaluations ON recordings.id = evaluations.recording_id
GROUP BY agent_id) AS T;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment