AuthorName in descending order within each country group as follows:
AuthorID
AuthorName
Country
Sex
1 10
William Shakespeare
United Kingdom
Male 1564
YearOfBirth
2
16
Virginia Woolf
United Kingdom
Female 1882
3
3
Jane Austen
United Kingdom Female 1775 Male 1892
4
7
J.R.R. Tolkien
United Kingdom
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
Female 1890
10
14
Toni Morrison
United States
11
2
Stephen King
United States
Female 1931
Male 1947
12 22
Maya Angelou
United States
Female 1928
13 6
Mark Twain
United States
Male 1835
14
21
Kurt Vonnegut
United States
Male 1922
15 17
John Steinbeck
United States
Male
1902
16 8
Harper Lee
United States
Female 1926
17 12
F. Scott Fitzgerald
United States
Male 1896
18 9
Ernest Hemingway
United States
Male 1899
19 19
Emily Dickinson
United States
Female 1830
Picture 4.1
Question 5:
Write a query to display GenreID, GenreName, NumberOfBookCopies corresponding to each genre, where NumberOfBookCopies is the number of copies of books published after the year 1980 of each genre. Order the results in descending order of NumberOfBookCopies, then in ascending order of GenreName for rows having the same
+ 100%
Close
