Skip to content

Instantly share code, notes, and snippets.

@grkvlt

grkvlt/stats.sql

Created February 27, 2019 20:43
Show Gist options
  • Save grkvlt/df426b9e70ea1754696172efde95924e to your computer and use it in GitHub Desktop.
Save grkvlt/df426b9e70ea1754696172efde95924e to your computer and use it in GitHub Desktop.
Download ZIP
ChristianRockOrNot Statistics SQL
Raw
stats.sql
SELECT
COUNT(TrackId) AS 'Tracks',
SUM(Total) AS 'Count',
SUM(Correct) AS 'Guessed',
(((SUM(Correct) * 100.0) / (SUM(Total) * 100.0)) * 100) AS 'Percent'
FROM ChristianRockOrNot;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment