Subject Computer Science Database Development

Question

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 Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.


-- Task 1: Return the total number of reviews

select count(*) from review;...

This is only a preview of the solution. Please use the purchase button to see the entire solution

Assisting Tutor

Related Homework Solutions

Introduction to Distributed Database Systems
Homework Solution
$50.00
Computer Science
Database Development
Distributed Systems
Queries
Clauses
Relation Algebra
Tables
Classes
Relationships
Database Design for Video Store
Homework Solution
$50.00
Computer Science
Database Development
Design
Video Store
Customers
Renting
Managers
Relationships
Attributes
Oracle/Eclipse Tutorial on Book Search
Homework Solution
$30.00
Computer Science
Database Development
Java
Tables
Sequences
Projects
Classes
Books
Search
Connections
Records
Arguments
Strings
Users
Actions
Database Problems With Countries
Homework Solution
$25.00
Computer Science
Database Development
Countries
Access Queries
Orders
Square Kilometers
Population
Land Area
Sorting
Consumption
People
Oil
Calculations
Columns
Barrel
Prices
Database Normalization Problems
Homework Solution
$43.00
Computer Science
Database Development
Software Contract
Consultancy Firm
Projects
Employees
Supervisors
Codes
Third Normal Form
Entities
Attributes
Transaction Management & Concurrency Control
Homework Solution
$128.00
Computer Science
Transaction Management
Concurrency Control
Database Systems
Algorithms
ACID Properties
Deadlocks
Commands
Get help from a qualified tutor
Live Chats