Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE book_rating (id TINYINT, name CHAR(30), star_rating TINYINT);
- INSERT INTO book_rating VALUES (1, 'Lord of the Ladybirds', 5);
- INSERT INTO book_rating VALUES (2, 'Lord of the Ladybirds', 3);
- INSERT INTO book_rating VALUES (3, 'Lady of the Flies', 1);
- INSERT INTO book_rating VALUES (4, 'Lady of the Flies', 2);
- INSERT INTO book_rating VALUES (5, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (6, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (7, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (8, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (9, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (10, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (11, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (12, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (13, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (14, 'Lady of the Flies', 5);
- INSERT INTO book_rating VALUES (15, 'Lady of the Flies', 5);
- // This works as expected
- SELECT name, median(star_rating) OVER (PARTITION BY name) FROM book_rating;
- // This doesn't work
- SELECT name, median(star_rating) OVER (ORDER by id ROWS 3 preceding) from book_rating
- // This works as expected
- SELECT name, avg(star_rating) OVER (ORDER by id ROWS 3 preceding) from book_rating
Add Comment
Please, Sign In to add comment