Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Code examples for SQL 1x1 blog-article - 10
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