Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT reg.name, (CASE
- WHEN EXTRACT(YEAR FROM y_real) BETWEEN 2006 AND 2009 THEN r.name
- ELSE repeat(' ',28)
- END) AS "2006-2009",
- (CASE
- WHEN EXTRACT(YEAR FROM y_real) BETWEEN 2010 AND 2012 THEN r.name
- ELSE repeat(' ',28)
- END) AS "2010-2012",
- (CASE
- WHEN EXTRACT(YEAR FROM y_real) BETWEEN 2013 AND EXTRACT(YEAR
- FROM CURRENT_DATE) THEN r.name
- ELSE repeat(' ',28)
- END) AS "2013-now"
- FROM rodoviwe r JOIN oblast o ON r.id_obl = o.id JOIN region reg ON reg.id = o.id_reg;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement