Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT EXTRACT(YEAR FROM data_egz) AS Rok,
- CASE EXTRACT(MONTH FROM data_egz) WHEN 1 THEN 'Styczeń'
- WHEN 2 THEN 'Luty'
- WHEN 3 THEN 'Marzec'
- WHEN 4 THEN 'Kwiecień'
- WHEN 5 THEN 'Maj'
- WHEN 6 THEN 'Czerwiec'
- WHEN 7 THEN 'Lipiec'
- WHEN 8 THEN 'Sierpień'
- WHEN 9 THEN 'Wrzesień'
- WHEN 10 THEN 'Październik'
- WHEN 11 THEN 'Listopad'
- ELSE 'Grudzień'
- END AS Miesiac,
- COUNT(e.nr_egz) AS "Liczba egzaminów"
- FROM egzaminy e
- GROUP BY EXTRACT(YEAR FROM data_egz), CASE EXTRACT(MONTH FROM data_egz) WHEN 1 THEN 'Styczeń'
- WHEN 2 THEN 'Luty'
- WHEN 3 THEN 'Marzec'
- WHEN 4 THEN 'Kwiecień'
- WHEN 5 THEN 'Maj'
- WHEN 6 THEN 'Czerwiec'
- WHEN 7 THEN 'Lipiec'
- WHEN 8 THEN 'Sierpień'
- WHEN 9 THEN 'Wrzesień'
- WHEN 10 THEN 'Październik'
- WHEN 11 THEN 'Listopad'
- ELSE 'Grudzień'
- END,
- EXTRACT(MONTH FROM data_egz)
- ORDER BY 1, EXTRACT(MONTH FROM data_egz) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement