Refer the given table and answer the question that follow: Each question carries Table: LIBRARY Book_ld Book_Name Book_Type Book_Author | 101 102 |Thinking in Java SQL Programming Bruce Eckel...

Answer for (a) (b) (c)

Extracted text: Refer the given table and answer the question that follow: Each question carries Table: LIBRARY Book_ld Book_Name Book_Type Book_Author | 101 102 |Thinking in Java SQL Programming Bruce Eckel Programming Ivan Bayross Purchase_Date Price 01-OCT-1997 2000 02-MAY-1998 3000 103 CALCULUS Maths Gilbert Strang 15-JAN-2000 4000 Web Application Development Programming SemmyPurewal 01-JAN-1997 Introduction to Algorithms 104 3500 Algorithm Bruce Eckel 01-JAN-2001 105 3000 TABLE: MEMBER Member_No Member_Name Book_ID Issue_date Return_date Fine RAGHAV 13-OCT-1998 12-JUN-2016 23-FEB-2000 23-FEB-1997 23-FEB-2001 13-NOV-1998 26-AUG-2016 26-MAR-2000 22-MAY-1997 22-MAY-2001 M101 101 M102 MI01 M103 |M102 ANISHA 102 150.255 SARTHAK SINHA JOHN 103 250.355 104 300.305 105 140.255 ACIivate windov a) Write an SQL query to display the Bookid. Book Name. Purchase Date of books, where books Purchase Date is between 15-OCT-1997 and 01-MAY-2001 and order the records in ascending order using PURCHASE, DATE. [ Hint: Library Table) b) Write an SQL query to display the Book.Jd, Fine and terminate the fine column with two decimal places whose member name ends with "HA. [ Hint Member Table] e) Write an SQL query to extract the first two characters of Member No, extract the first three characters of Member Name and display the output in lowercase characters. [ Hint: Member Table) d) Write an SQL query to display the unique members for books returned (Return_date) by the members in MAY.( Hint Member Table)