4 of 4
Paper No: 7
AuthorID
AuthorName
Country
Sex
YearOfBirth
1
1
J.K. Rowling United Kingdom Female
1965
2
3
Jane Austen United Kingdom Female 1775
3
5
Agatha Christie United Kingdom Female 1890
4
16
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 3
AuthorName
Country United Kingdom
1
3
Pride and Prejudice
1813
Jane Austen William Shakespeare United Kingdom
2
10
Hamlet
1603
10
3 11
Great Expectations
1861
11
Charles Dickens United Kingdom
4
20
The Adventures of Sherlock Holmes 1892
20
Arthur Conan Doyle United Kingdom Jane Austen United Kingdom
5 33
Sense and Sensibility Romeo and Juliet
1811
3
6 40
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 Jane Austen United Kingdom
9 53
Northanger Abbey
1817
3
10 60
King Lear
1606
10
William Shakespeare United Kingdom
11 61
Bleak House
1852
11
Charles Dickens United Kingdom
Zoom
+ 100%
Close
