Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT isbn,book_title,book_author,year_of_publication, avg(book_rating) avg_rate
- FROM yvasileva_talend.books
- WHERE year_of_publication>=2000
- GROUP BY isbn,book_title,book_author,year_of_publication
- HAVING avg_rate>5
- ORDER BY avg_rate DESC
- LIMIT 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement