Useful Code snippets

Code examples useful for query construction

Pull out Juv/YA Age Level from Location code

CASE
WHEN SUBSTRING(i.location_code,4,1)='j' THEN 'Juv'
WHEN SUBSTRING(i.location_code,4,1)='y' THEN 'YA'
Else 'Adult'
END AS "Age level"