Skip to content

Instantly share code, notes, and snippets.

@databraineo

databraineo/sql1x1-10.sql

Created August 16, 2019 08:17
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 databraineo/2e3f468765c7a3f97fd0cb4e0c0a4e13 to your computer and use it in GitHub Desktop.
Save databraineo/2e3f468765c7a3f97fd0cb4e0c0a4e13 to your computer and use it in GitHub Desktop.
Download ZIP
Code examples for SQL 1x1 blog-article - 10
Raw
sql1x1-10.sql
SELECT
Name,
substr(Name,1,1) AS [Index],
CASE WHEN Milliseconds > 360000 THEN '> 6min.'
WHEN Milliseconds > 300000 THEN '5-6 min.'
WHEN Milliseconds > 240000 THEN '4-5 min.'
ELSE 'kurz'
END AS Länge
FROM Track;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment