1. Find all find all customer orders placed between January 2014 and June 2014. Provide the SQL statement below:
2. Create a new query to display all authors with last name of "Smith" and all books by this author. Show author id, author first name, author last name, title id, and title. Group data by title id. Provide the SQL statement below:
3. Update the new fields added to the book table for title id 123. Please provide the SQL statement below.
4. Delete all orders placed before January 2011. Provide the SQL statement below.

Transcribed Image Text:

Authors BooksAuthors Books Authors AuthorID 00 TitlelD TitlelD AuthorID ConditionID ConditionName Description Title FirstName LastName Publisher PubDate YearBom YearDied Description Edition 00 Cost SRP ConditionID Sold BooksOrders OrderlD TitlelD Employees Orders Positions Customers OrderlD EmployeelD PositionID CustomeriD FirstName CustomerID FirstName Title JobDescrip EmployeelD LastName LastName Amount Address1 Phone OrderDate Address2 Address1 DeliveryDate PaymentID StatusID City State Zip Address2 City 00 State Phone Zip DOB HireDate PositionID FormofPayment OrderStatus PaymentID PaymentDescrip StatusID StatusDescip