Skip to content

Instantly share code, notes, and snippets.

@andikasputra

andikasputra/query-1.sql

Created October 6, 2018 00:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andikasputra/b1c65c18524b35fc358b3769273872d7 to your computer and use it in GitHub Desktop.
Save andikasputra/b1c65c18524b35fc358b3769273872d7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query-1.sql
SELECT level, COUNT(id) AS jml
FROM soal
GROUP BY level;
Raw
query-2.sql
SELECT
SUM(CASE WHEN level = 'mudah' THEN 1 ELSE 0 END) AS mudah,
SUM(CASE WHEN level = 'sedang' THEN 1 ELSE 0 END) AS sedang,
SUM(CASE WHEN level = 'sulit' THEN 1 ELSE 0 END) AS sulit
FROM soal;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment