3.7.2 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.

Describe the purpose of the SELECT statement in SQL.

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.

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

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.