7 of 7
Paper No: 6
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.
NumberOfLoans ByFemale Members NumberOfLoans By Male Members
AuthorID AuthorName
1234-5
1
J.K. Rowling
1
1
2
Stephen King
1
2
3
Jane Austen
2
4
4
George Orwell 3
2
5
Agatha Christie 1 Mark Twain
2
6
6
2
1
7
7
J.R.R. Tolkien 1 Harper Lee
4
8 8
1
4
9
9
Ernest Hemin... 1
3
10 10
William Shak... 2
2
11
11
Charles Dick... 0
1
12 12
F. Scott Fitzg... 1
2
13 13
Gabriel Garcí... 3
4
14 14
Toni Morrison
2
5
15 15
Leo Tolstoy
4
1
16 16
Virginia Woolf 1
3
17 17
John Steinbeck 1 Franz Kafka
3
18 18
2
5
19 19
Emily Dickins... 3 Arthur Conan... 1
5
20 20
1
21 21
Kurt Vonnegut 0 Maya Angelou 0
0
0
23 23
Salman Rush... 0
0
24 24
Margaret Atw... 0 Haruki Murak... 0
0
25 25
0
Picture 7.1
Question 8:
Create a stored procedure named insertMember with @memberID int,@memberNamenvarchar(100), @address nvarchar(200), @email nvarchar(100), @sex nvarchar(20),@birthDate date as input parameters of the procedure. The stored procedure attempts to insert a new member into the table Members, but only if a member with the same MemberID does not already exists:
- if a member with MemberID = @memberID already exists, the procedure does nothing.
- if there is no member with MemberID = @memberID, the procedure will insert into the table Members a new row with @memberID, @memberName, @address, @email, @sex and @birthDate as values for its attributes.
+ 100%
Close
