Books(ISBN, Name, Price, NumberOfCopies)

-Identify a primary key generate and execute a python SQL DDL command to Create table.

-Make your own data and insert 10 rows in the table created using python SQLite.

-Retrieve all the records from the table Books.

-Insert another record in the table as ('9875465248','Programming With Python',100,50)

-Update the record inserted above – Price -> new Value -> 60 and Number of copies -> new value -> 100

-Delete the record from the above table where number of copies = 100

-Retrieve all the records again from the Books table.

-Retrieve sum of all copies and the avg price from the above table.

Answer rating: 100% (QA)

To perform the tasks you ve outlined you can use Python with the SQLite library to interact with a d View the full answer