3.7 Relational Databases and Structured Query Language (SQL)

The Books table contains BookID, Title, and Author. A book needs to be deleted from the database where the Title is “The Lord Of The Rings”. Construct the SQL DELETE statement for this operation.

Given a table Orders with columns OrderID, ProductID, Quantity, and OrderDate, write an SQL statement to update the Quantity of an order to 3 where the OrderID is 102.

A table Players contains columns PlayerID, PlayerName, and Score. Write an SQL query to insert a new record into the table.

Write an SQL query to retrieve the CustomerName and PurchaseDate for all records in the Purchases table where the PurchaseAmount is greater than £500.00. Results should be ordered by PurchaseDate in descending order.

Describe the purpose of the SELECT statement in SQL.