Seagull

Lesson 8 - 15. View of Books Without Votes and Test with Invented Books

Dataset statusEasy SQL exercisesvv1

Exercise content

Create a view fp_books_without_votes that shows book_id and book_name for the books in books that have not received any votes in book_stars.
Insert these two invented books into the books table:
- 30001, 'Invented SQL Patterns', 'Imaginary Press'
- 30002, 'Fictional Data Stories', 'Imaginary Press'
Verify that the view also includes the two new books you just inserted.

Hints

Hint 1
The view must read from books and show only book_id and book_name. The required name is fp_books_without_votes.
Hint 2
You need to exclude the books that appear in book_stars. You can reason with a subquery on the already voted book_id values.
Hint 3
After CREATE VIEW, add two rows to books with INSERT. If the view is correct, it will include the new books too.

Not completed

Loading dataset...

Latest result

No result set available.