Problem Statement

Listing Employees Named Smith or Pears With More Than 18 Orders Consider the following schemas: Orders (OrderID, CustomerID, EmployeeID, OrderDate, ShipperID) Employees (EmployeeID, LastName, FirstName, BirthDate, Photo, Notes) Which of the following SQL statements lists whether the employees with last name "Smith" or "Pears" have registered more than 18 orders? Choose the most appropriate alternative from the options given below.