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)

Solution PreviewSolution 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:

50% discount

$28.00 $14.00
for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Upload a file
Continue without uploading

We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats