Problem 1. Please write ONE SQL statement for each of the following tasks using tables created in Problem 1.
Task 1: Return the total number of reviews
Task 2: Return all reviews submitted after 2016-5-1.
Task 3: Return product names under the category TV.
Task 4: Return the product name and average score.
Task 5: Return the names of product under the category TV and with average rating above 4.0
Task 6: Return names of products under the same category as Apple iPhone 6 Plus
Task 7: Return the name of user whose minimal review score is at least 4.5.
Task 8: Return the name of the laptop with the lowest weight (Hint: using subquery in where clause)
Question
Solution Preview
These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.
-- Task 1: Return the total number of reviews
select count(*) from review;...
By purchasing this solution you'll be able to access the following files:
Solution.txt.
Return to homework library