Zoom
name:nvarchar(50)
Picture 1.1
Question 2:
Display all female authors whose country is 'United Kingdom' as follows:
4 of 4
Paper No: 2
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:
Publication Year
AuthorID
AuthorName
BookID Title
Country
1
3
Pride and Prejudice Hamlet
1813
3
Jane Austen
United Kingdom
2
10
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
+ 100%
Close
