ES.1c- Display the ProductUD ProdustName, and Product Price for products with a
ID: 3715305 • Letter: E
Question
ES.1c- Display the ProductUD ProdustName, and Product Price for products with a ProductPrice of $100 and higher E5.1d- Display the ProductID ProductName, roductPrice, and VendorName for all products. Sort the results by ProductIl E5.1f (by join)-Display the ProductlD, ProductName, and ProductPrice for products in the category whose CategoryName value is Camping. Sort the results by ProductlD E5.1f (by subquery)- Display the ProdustlD, ProductName, and ProductPrice for products in the category whose CategoryName value is Camping. Sort the results by ProductlD ES.11- Display the ProductID and ProductName of the cheapest product E6.1a- If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES REP and TERRITORY, show the records in tables SALES REP and TERRITORY after a user tries to delete the fourth record (N, North) from TERRITORY E6.1b- If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES REP and TERRITORY, show the records in tables SALES REP and TERRITORY after a user tries to delete the second record (W, West) from TERRITORY E6.1c-If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES REP and TERRITORY, show the records in tables SALES REP and TERRITORY after a user tries to delete the first record (1, Joe, E) from SALES_REP E6.1d- If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between SALES REP and TERRITORY, show the records in tables SALES REP and TERRITORY after a user tries to delete the fourth record (N, North) from TERRITORY E6.1e- If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between SALES REP and TERRITORY, show the records in tables SALES REP and TERRITORY after a user tries to delete the second record (W, West) from TERRITORY E6.1f-lf a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between SALES REP and TERRITORY, show the records in tables SALES REP and TERRITORY after a user tries to delete the first record (1, Joe, E) from SALES_REExplanation / Answer
Answer#1
select ProductID, ProductName, ProductPrice from products where ProductPrice>100;
Answer#2
select ProductID, ProductName, ProductPrice, VendorName from products ORDER BY ProductID;
Answer#3
select ProductID, ProductName, ProductPrice from products where CategoryName LIKE 'Camping%' ORDER BY ProductID;
Answer#4
Question cant be solved by subquery
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.