Question: Question 4 (Total 15 Points): Answer questions based on the following schema (data types are not needed) Customer (cid, ename, age, gender) Buys (cid, pid,
Question 4 (Total 15 Points): Answer questions based on the following schema (data types are not needed) Customer (cid, ename, 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'. 4.2) (4 Points) Find names 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. 4.4) (3 Points) write a SQL statement to decrease the amount of all price in Product table by 3% 4.5) (2 Points) Write a SQL statement to select all Customers Age where Age has a null value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
