Consider the tables provided below and answer the following SQL questions: Table 1: Book Title Issue...

Transcribed Image Text:

Consider the tables provided below and answer the following SQL questions: Table 1: Book Title Issue Date MemberID Database 983939323 10/05/2021 2 System Analysis 942857878 02/03/2021 1 Programming 955265622 26/03/2021 2 942637537 15/04/2021 3 Cloud Computing ISBN Table 2: Member MemberID FirstName LastName Email 1 2 3 Mark Smith Mark.smith@gmail.com Sarah Lynt Sarah.lynt@gmail.com David Lochlan David.lochlan@gmail.com a. Write insert statements to enter first two records into Table 1 as shown in above figure. b. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. C. Display the first name, last name and email of members who have borrowed Database book. Consider the tables provided below and answer the following SQL questions: Table 1: Book Title Issue Date MemberID Database 983939323 10/05/2021 2 System Analysis 942857878 02/03/2021 1 Programming 955265622 26/03/2021 2 942637537 15/04/2021 3 Cloud Computing ISBN Table 2: Member MemberID FirstName LastName Email 1 2 3 Mark Smith Mark.smith@gmail.com Sarah Lynt Sarah.lynt@gmail.com David Lochlan David.lochlan@gmail.com a. Write insert statements to enter first two records into Table 1 as shown in above figure. b. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. C. Display the first name, last name and email of members who have borrowed Database book.

Answer rating: 100% (QA)

The detailed answer for the above question is provided belo... View the full answer