7 of 7
Paper No: 11
members in which books of the corresponding author were borrowed. Note that all authors must be displayed in the results as in the following figure.
NumberOfLoansByFemale Members
NumberOfLoans ByMaleMembers
AuthorID AuthorName
1
1
J.K. Rowling
1
1
234-
2
Stephen King
1
2
34-
Jane Austen
2
4
George Orwell 3
2
5
5
Agatha Christie 1 Mark Twain
2
6 6
2
1
7
7
J.R.R. Tolkien 1
4
8
8
Harper Lee
1
4
9
9
Ernest Hemin... 1 William Shak... 2
3
10
10
2
Charles Dick... 0
1
12 12
F. Scott Fitzg... 1 Gabriel Garcí... 3
2
13 13
4
14 14
Toni Morrison 2
5
15 15
Leo Tolstoy
4
1
16 16
Virginia Woolf 1 John Steinbeck 1
3
17 17
3
18 18
Franz Kafka
2
5
19 19
Emily Dickins... 3
5
20 20
Arthur Conan... 1
1
21 21
Kurt Vonnegut 0
0
Maya Angelou 0
0
23 23
Salman Rush... 0
0
24 24
Margaret Atw... 0
0
25 25
Haruki Murak... 0
0
Picture 7.1
Question 8:
Create a stored procedure named insertAuthor with @authorID int, @authorNamenvarchar(100), @country nvarchar(100), @sex nvarchar(10), @yearOfBirth int as input
Close
+ 100%
