SQL

Question 12 Q11. Write an SQL query to do the following: Not yet answered Marked out of 10.00 Flag question a. Create table Library with the given details. ID BName Pch_Date Varchar2(3). Varchar2(15) Date Primary key (2 Marks) Price Number(5,2). Default 0 (1 Mark) (Mark) b. Add constraint Not null to the column BName c. Insert the following records into the table Library. ID BName Pch_Date B12 Sql 20/05/2019 B14 Database 15/10/2018 B16 Python 06/06/2020 Price 100.00 75.25 125.50 d. Change the Purchase Date of book SQL to 06/06/2020 (1 Mark) Q12: Use the Library table for the following queries. a. Display all details of Books with name ends with letter e. (1 Mark) b. Display Id and Price of SQL book purchased on 06/06/2020 (1 Mark) c. Display name of Books in the descending order of Name. (1 Mark) d. Display the details of Books with price 100 and 125,50 (1 Mark) e. Decrease the price of book python by 20 and in the output display column name as NewPrice (1 Mark)