Question: 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

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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Computer Network Questions!