name:
nvarchar(50)
Picture 1.1
Question 2:
Display all male members who were born after the year 1990 as follows:
4 of 4
Paper No: 6
MemberID MemberName
Address
Email
Sex BirthDate Male 1995-07-03
1
9
David Wilson
666 Spruce St, Everywhere, USA
[email protected] [email protected]
13
Daniel Thomas 111 Maple St, Nowhere, USA
Male 1991-04-18
3
19
Benjamin Garcia 777 Birch St, Everywhere, USA
[email protected] Male 1996-08-18
4
25
Mason Perez
101 Elm St, Everywhere, USA 777 Cedar St, Anytown, USA
[email protected]
Male 1996-04-05
5 31
Liam Garcia Jack Taylor
[email protected]
Male 1994-03-18
6 37
101 Cedar St, Somewhere, USA
[email protected]
Male 1992-07-31
Picture 2.1
Question 3:
Write a query to select BookID, Title, Publication Year, GenreID, GenreName corresponding to all books published in the year of 1900 or earlier of the genre named 'Adventure' as follows:
BookID Title
Publication Year GenreID
GenreName
1
6
The Adventures of Huckleberry Finn 1884
9
Adventure
2
36
Tom Sawyer
1876
9 Adventure
3 56
The Prince and the Pauper
1881
9 Adventure Adventure
4
76
Adventures of Tom Sawyer
1876
9
5 96
Adventures of Huckleberry Finn 1884
9 Adventure
Picture 3.1
Question 4:
Write a query to display GenreID, GenreName of all distinct genres which have books published after 1980 borrowed in at least one loan. Display the results in ascending order of GenreName as follows:
+ 100%
GenrelD GenreName
Close
