sql

Qil. Write an SQL query to do the following: ID a. Create table Library with the given details. BName Pch Date Varchar2(3). Varchar2(15) Date Primary key (2 Marks) Price Number(5,2). Default 0 (1 Mark) (1 Mark) ID b. Add constraint Not null to the column BName c. Insert the following records into the table Library. 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)