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

$28.00

or $1 if you
register a new account!

Assisting Tutor

Related Homework Solutions

SQL Server Installation Report
Homework Solution
$20.00
SQL Server
Installation
How To
Guide
Computer
Science
Database
Development
Murach
Script
Management
Data Mining and Warehouse Assignment
Homework Solution
$20.00
Flight
Data
Warehouse
OLAP
Dimension
Fact
Table
Cube
Operation
Business
Time
Arrival
Star
Schema
Doctor
Patient
SQL
Query
Relational
Database
Departure
Traveler
Roll-up
Select
Database System Concepts
Homework Solution
$55.00
Transaction
Atomicity
Consistency
Isolation
Durability
Schedule
Dirty
Read
Serializable
Strict
2Pl
Action
Object
Concurency
Control
Interference
Data
Model
Relational
Hierarchical
Network
Object-oriented
Single
Multi
User
Centrali
Oracle DB/Server Related Questions
Homework Solution
$20.00
Computer
Science
Oracle
Database
Password
User
Table
System
Tablespace
Non-system
Object
Action
Control
File
Lists
DBA
SYS
Query
Connect
Sysdba
Sql
Oradata
Sysasm
Get help from a qualified tutor
Live Chats