4 16
Agatha Chistle Onited Kingdom remare 1090 Virginia Woolf United Kingdom Female 1882
Picture 2.1
Question 3:
Write a query to select BookID, Title, Publication Year, AuthorID, AuthorName, Country corresponding to all books which were published in the year 1920 or earlier of authors from 'United Kingdom' as follows:
BookID Title
Publication Year
AuthorID
AuthorName
Country
1
3
Pride and Prejudice
1813
3
Jane Austen
United Kingdom
2
10
Hamlet
1603
10
William Shakespeare United Kingdom
3
11
Great Expectations
1861
11
Charles Dickens
United Kingdom
4
20
The Adventures of Sherlock Holmes 1892
20
Arthur Conan Doyle United Kingdom
5 33
Sense and Sensibility
1811
3
Jane Austen United Kingdom
6 40
Romeo and Juliet
1597
10
William Shakespeare United Kingdom Charles Dickens United Kingdom
7
41
A Tale of Two Cities
1859
11
8 50
The Adventures of Sherlock Holmes 1892
20
Arthur Conan Doyle United Kingdom
9 53
Northanger Abbey
1817
3
Jane Austen United Kingdom
10 60
King Lear Bleak House
1606
10
William Shakespeare United Kingdom United Kingdom
11 61
1852
11
Charles Dickens
12 70
The Memoirs of Sherlock Holmes
1894
20
Arthur Conan Doyle United Kingdom
13 73
Persuasion
1817
3
Jane Austen United Kingdom
14 80
The Tempest
1610
10
William Shakespeare United Kingdom Charles Dickens United Kingdom
15 81
Oliver Twist
1837
11
16 90
The Return of Sherlock Holmes
1905
20
Arthur Conan Doyle United Kingdom
17 93
Mansfield Park
1814
3
Jane Austen
United Kingdom
18 100
Othello
1603
10
William Shakespeare United Kingdom
19 101
A Christmas Carol
1843
11
Charles Dickens United Kingdom
20 110
The Adventures of Sherlock Holmes 1892
20
Arthur Conan Doyle United Kingdom
Picture 3.1
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 GenreName as follows:
Zoom
+ 100%
Close
