Skip to content

Instantly share code, notes, and snippets.

@anitaokoh

anitaokoh/second.sql

Created July 2, 2019 14:43
Show Gist options
  • Save anitaokoh/a22f8fab32765e1698fbdd50abf6cdd1 to your computer and use it in GitHub Desktop.
Save anitaokoh/a22f8fab32765e1698fbdd50abf6cdd1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
second.sql
SELECT name, SUM(intelligence + strength + speed + durability + Energy_projection + Fighting_skills) as Power_rate
FROM power_average
GROUP BY name
ORDER BY Power_rate DESC
LIMIT 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment