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:
Zoom
5 of 5
Paper No: 2
AuthorID
AuthorName
Country
Sex
YearOfBirth
1
10
William Shakespeare
United Kingdom
Male
1564
2
16
Virginia Woolf
United Kingdom Female 1882 1775
3
3
Jane Austen
United Kingdom
Female
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 Molo
1812
+ 100%
Close
