Question 3:
4 of 4
Paper No: 5
Write a query to select BookID, Title, Publication Year, GenreID, GenreName corresponding to all books published in the year of 1900 or earlier of the genre named 'Adventure' as follows:
BookID Title
6
36
Publication Year
The Adventures of Huckleberry Finn 1884
Tom Sawyer
The Prince and the Pauper
Adventures of Tom Sawyer
Adventures of Huckleberry Finn
Picture 3.1
1876
1881
1876
1884
GenreID GenreName
9
9
9
9
9
Adventure
Adventure
Adventure
Adventure
Adventure
1
2
3 56
4
76
5 96
Question 4:
Write a query to display GenreID, GenreName of all distinct genres which have books published after 1980 borrowed in at least one loan. Display the results in ascending order of
+ 98%
Zoom
Close
