ALTER SESSION SET CURRENT_SCHEMA = COP6731;

Please note that the schema name is defined as upper case characters.

Use the spool command to create a log file for the output of SQL (e.g., SPOOL filename and SPOOL OFF)

Write SQL statements for the following queries. 1) Retrieve all names of products that were purchased by 'Kailani Benham' on 29-03- 23 at the store located at '22100 Fl-7, Boca Raton, Fl 33428'. 2) Retrieve the ids and the first and last names of employees who have no supervisor and are older than 80. 3) Retrieve the ids and the first and last names of customers who purchase the 'Seasense Rope Ladder' product. 4) Retrieve the ids and the first and last names of customers who purchase no item. 5) Retrieve the ids and the first and last names of customers who purchase 'Seasense Rope Ladder' or 'Sloth Face Ice Hockey Puck' products. 6) Retrieve the ids and the first and last names of customers who purchase both 'Seasense Rope Ladder' and 'Sloth Face Ice Hockey Puck' products. 7) Retrieve the first and last names of the oldest customers whose salary is greater than 400000. 8) Retrieve the names of brands whose brand value is greater than 98 and contains more than 10 products. 9) Retrieve the first and last names of customers who purchase and return the same item on the same date. 10) Retrieve the first and last names of customers who purchases all items of the 'Q- Tees Hemmed Fingertip Towel' product.

D INTEGER NAME VARCHAR2(90)