Advertisement
Guest User

Untitled

a guest
Nov 29th, 2015
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. SELECT reg.name, (CASE
  2. WHEN EXTRACT(YEAR FROM y_real) BETWEEN 2006 AND 2009 THEN r.name
  3. ELSE repeat(' ',28)
  4. END) AS "2006-2009",
  5. (CASE
  6. WHEN EXTRACT(YEAR FROM y_real) BETWEEN 2010 AND 2012 THEN r.name
  7. ELSE repeat(' ',28)
  8. END) AS "2010-2012",
  9. (CASE
  10. WHEN EXTRACT(YEAR FROM y_real) BETWEEN 2013 AND EXTRACT(YEAR
  11. FROM CURRENT_DATE) THEN r.name
  12. ELSE repeat(' ',28)
  13. END) AS "2013-now"
  14. 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