Question: Please check if number 1 is correct need help with the 2 and 3 Answer questions based on the following schema (data types are not
Answer questions based on the following schema (data types are not nee Customer (cid, cname, age, gender) Buys (cid, pid, quantity) Product (pid, pname, type, manufacturer, price) 4.1) (2 Points) Find names and types of all products that are manufactured by 'Sears'. Salect pnome, type fro m product whert manu facter5cars e a gender of ors of all customers who have purchased a product that is manufactured by 'Acme' and have a gender of Coyote' 4.3) (4 Points) Find type and price of all products that have been purchased by a customer who is older than 42 years old and quantity> 10
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
