Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT kwartal,
- LICZBA_SPRZEDANYCH,
- RANK() OVER (ORDER BY LICZBA_SPRZEDANYCH DESC) RANK_LS,
- CAST((LICZBA_SPRZEDANYCH/LICZBA_W_ROKU)*100 AS DECIMAL(10,2)) udzial_w_roku
- FROM
- (SELECT DISTINCT TO_CHAR(TIME_ID, 'YYYY-Q') kwartal,
- SUM(quantity_sold) OVER (PARTITION BY TO_CHAR( TIME_ID, 'YYYY-Q')) LICZBA_SPRZEDANYCH,
- SUM(quantity_sold) OVER (PARTITION BY TO_CHAR(TIME_ID, 'YYYY')) LICZBA_W_ROKU
- FROM SH.sales)
- ORDER BY kwartal
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement