For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed.

1. What are the names of customers who have bought products costing over $60 made by manufacturers in New Jersey? Show first and last names.

2. Which employees purchased sneakers (made purchases) from the manufacturer named Timberland? Show first and last employee names only.

3. Who are the customers (first and last names) that bought "casual shoes" from the manufacturer named Timberland? (Note category names are lower case, manufacturer names are capitalized in the database.)

4. Who are the customers from Illinois who have bought products costing over $100 or who have bought flats? Show first and last name only.

6.2s Join Queries on full Redcat DB (MS SQL Server) For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed