Please write this in SQL

8. List the product names of boots made in New Hampshire. Use a subquery in the WHERE clause. Category data is a lower case in the database.

"boots" is a category and "New Hampshire" is a state

9.

List the names and list prices of products that sold only in a quantity of 2. In other words, in a quantity of 2 but not in any other quantities.

Hint: You will have to use 2 subqueries in the WHERE clause (not nested). The first subquery will select only those records where quantity is 2. The second subquery will select all those records where quantity is NOT 2. These two subqueries must be true at the same time.

Customer Saleltem Product Manufacturer Customer D - SaleID ProductID FirstName ProductID ProductName Sale SaleID SaleDate CustomerID Tax Shipping Item Size LastName Street Address ManufacturerID Composition ManufacturerID O ManufacturerName Address1 Address2 City Quantity Sale Price ListPrice Gender State City State Postal Code Country Employee PostalCode Category Color EmployeelDO Phone Phone FirstName Fax Description SalaryEmployee Contact URL Employeeld Salary LastName Address City State ZIP Phone ManagerID SSN WageEmployee Employeeld 0 Wage MaxHours Email Address Hire Date