4 of 4
Paper No: 11
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
Publication Year
GenrelD
GenreName
1
6
The Adventures of Huckleberry Finn 1884
9
Adventure
2
36
Tom Sawyer
1876
9
Adventure
3 56
The Prince and the Pauper
1881
9
Adventure
4
76
Adventures of Tom Sawyer
1876
9
Adventure
5 96
Adventures of Huckleberry Finn 1884
9
Adventure
Picture 3.1
Question 4:
Write a query to display AuthorID, AuthorName, Country, Sex, YearOfBirth of all distinct authors from 'United Kingdom' or 'United States' who have books borrowed in at least one loan. Results must be ordered first by 'Country' in ascending order and then by
'AuthorName' in descending order within each country group as follows:
YearOfBirth
AuthorID
AuthorName
Country
Sex
1
10
William Shakespeare
United Kingdom
Male
1564
2
16
Virginia Woolf
United Kingdom
Female 1882
3
3
Jane Austen
United Kingdom Female 1775
4
7
J.R.R. Tolkien
United Kingdom Male 1892
5
1
J.K. Rowling
United Kingdom
Female 1965
6
4
George Orwell
United Kingdom
Male 1903
7
11
Charles Dickens
United Kingdom Male 1812 Male 1859
8 20
Arthur Conan Doyle
United Kingdom
9
5
Agatha Christie
United Kingdom United States
Female 1890
10
14
Toni Morrison
Female 1931
11
2
Stephen Kina
United States Male
Zoom
+ 100%
1947
Close
