Refer the given table and answer the question that follow: Each question carries Table: LIBRARY Book ld Book_Name Thinking in Java SQL CALCULUS Book Type Book_Author Programming Bruce Eckel Programming Ivan Bayross Purchase Date Price 01-OCT-1997 2000 02-MAY-1998 3000 101 102 103 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 M101 M102 MI01 M103 M102 RAGHAV ANISHA SARTHAK SINHA JOHN 13-NOV-1998 26-AUG-2016 26-MAR-2000 22-MAY-1997 22-MAY-2001 101 13-OCT-1998 12-JUN-2016 23-FEB-2000 23-FEB-1997 23-FEB-2001 102 150.255 103 250.355 104 300.305 105 140.255 ACIvate windov a) Write an SQL query to display the Book.id. 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 Bookjd, Fine and terminate the fine column with two decimal piaces 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)
Refer the given table and answer the question that follow: Each question carries Table: LIBRARY Book ld Book_Name Thinking in Java SQL CALCULUS Book Type Book_Author Programming Bruce Eckel Programming Ivan Bayross Purchase Date Price 01-OCT-1997 2000 02-MAY-1998 3000 101 102 103 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 M101 M102 MI01 M103 M102 RAGHAV ANISHA SARTHAK SINHA JOHN 13-NOV-1998 26-AUG-2016 26-MAR-2000 22-MAY-1997 22-MAY-2001 101 13-OCT-1998 12-JUN-2016 23-FEB-2000 23-FEB-1997 23-FEB-2001 102 150.255 103 250.355 104 300.305 105 140.255 ACIvate windov a) Write an SQL query to display the Book.id. 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 Bookjd, Fine and terminate the fine column with two decimal piaces 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)
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
Related questions
Question
Answer for (a) (b) (c)
![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)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3f6edcf5-84c1-49a1-8f29-6b946e0a023c%2F81aadc8a-5430-4b81-9ece-6a773af59fbe%2Fe8asie8_processed.jpeg&w=3840&q=75)
Transcribed Image 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)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning