Consider the following schema (keys are underlined): Product(pid, name, type, manufacturer, price) Buys(cid, pid) Customer(cid, cname, age, gender) Write the following queries: 1. Find the names of...

write following queries

Extracted text: Consider the following schema (keys are underlined): Product(pid, name, type, manufacturer, price) Buys(cid, pid) Customer(cid, cname, age, gender) Write the following queries: 1. Find the names of all customers who have purchased a product manufactured by Gizmo. 2. Find the cheapest expensive product 3. Find the most expensive product from each manufacturer 4. Find products that not being purchased 5. Find the names of all customers who have purchased the most expensive product.