444444543444333444444434444444255455542444451155442353544342UPSPSUni Fer Ma Ma Fer Fer Ma Ma Fer Ma F FM Ma Fer MMMMMFMFMMMM611829950736335335326926835243254135145542542444544318492Ma ma Sai Sai Sai Mi HP Mi Sa HP HP Mi Sai Mi Ap HF De De Saes es o o eslo es loN N Y N Y N Y N N N Y Y N N Y Y Y Y Nfor CA GA IL CA OH IL CA CA CA CACA CAIL IL FL ILIL CACA FL CA IL IL CA FLFneFe0021020880038518055111151151119939399369hFFFBhTBTB9299599493232942923032148929123939524bpbpppbppbpbLLTSTSrv 6 D .6 .6N11bL3gAALL3

Question
Asked Mar 7, 2019
3 views

I need help with understanding how to do the SQL code for the following question (attached is the CSV database file):

These are the header titles from the picture: ProductModelName, ProductCategory, ProductPrice, RetailerName, RetailerZip, RetailerCity, RetailerState, ProductOnSale, ManufacturerName, ManufacturerRebate, UserID, UserAge, UserGender, UserOccupation, ReviewRating, ReviewDate, Review Text

 

1. Get the total number of products reviewed and got Rating 5 in Every City

4444445434443334444
44434444444
2
5545554244445
1155442353544342
UPSPS
Uni Fer Ma Ma Fer Fer Ma Ma Fer Ma F FM Ma Fer MMM
MMFMFMMMM
6118299507
363353353269268
3524
32541351455425424445443
1849
2
Ma ma Sai Sai Sai Mi HP Mi Sa HP HP Mi Sai Mi Ap HF De De Sa
es es o o es
lo es lo
N N Y N Y N Y N N N Y Y N N Y Y Y Y N
for CA GA IL CA OH IL CA CA CA CA
CA CA
IL IL FL IL
IL CA
CA FL CA IL IL CA FL
FneFe
0021
020880
03851805511
115115111
993
939
9369
hFFFBhTBTB
929959949
3232942923032
148929123939524
bpb
pppbpp
bpb
LLTSTS
rv 6 D .6 .6
N11b
L3gAA
LL3
help_outline

Image Transcriptionclose

4444445434443334444 44434444444 2 5545554244445 1155442353544342 UPSPS Uni Fer Ma Ma Fer Fer Ma Ma Fer Ma F FM Ma Fer MMM MMFMFMMMM 6118299507 363353353269268 3524 32541351455425424445443 1849 2 Ma ma Sai Sai Sai Mi HP Mi Sa HP HP Mi Sai Mi Ap HF De De Sa es es o o es lo es lo N N Y N Y N Y N N N Y Y N N Y Y Y Y N for CA GA IL CA OH IL CA CA CA CA CA CA IL IL FL IL IL CA CA FL CA IL IL CA FL FneFe 0021 020880 03851805511 115115111 993 939 9369 hFFFBhTBTB 929959949 3232942923032 148929123939524 bpb pppbpp bpb LLTSTS rv 6 D .6 .6 N11b L3gAA LL3

fullscreen
check_circle

Expert Answer

star
star
star
star
star
1 Rating
Step 1

As the table name is not shown in the picture, we are assuming the table name as Product. There are multiple entities given for the table including ProductModelName, ProductCategory, ProductPrice, RetailerName, Re...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Fill in the following table to show how the given integers are represented, assuming that 16 bits ar...

A: Convert the integer value to binary:For positive integer:Divide the integer number by 2. The integer...

question_answer

Q: Consider the following two assertions. Assume x is a specific but unknown real number.a. x < 2 o...

A: Let us name the statements as following:For expression (a)A: x < 2B: Not(1 < x < 3)so the e...

question_answer

Q: Code should be in C++ Absolute Value Template: Write a function template that accepts an argument an...

A: Since Function Templates are used to handle all possible data types you can say generic data type at...

question_answer

Q: Create a new file in c++.  In this lab, you will add some functionality to the table ofmenu. Your bo...

A: Program Instructions:Declare variables and write a welcome message.Always convert the user's choice ...

question_answer

Q: Analyze the following code: Code 1: int number = 45;boolean even; if (number % 2 == 0) even = true;e...

A: First lets discuss about the first question. 1) In the first code we are declaring two variables num...

question_answer

Q: Exhibit an algorithm to determine whether or not a regular language L contains any string w such tha...

A: Solution: Given that,The following algorithm identify whether or not a regular language “L” contains...

question_answer

Q: What would the output be when the user taps or clicks the btnDrivingAge button   Private Sub btnDri...

A: Form1:

question_answer

Q: Write a complete C++ program that does the following:1. Create a 2-dimensional array with 8 rows and...

A: 1)Program plan:Declare the variables “rows” and “cols” as integerAssign “rows” to “8” and “cols” to ...

question_answer

Q: Develop the ‘Shape’ application such that: Implement an array of objects of various types (all SIX ...

A: Program plan:Define a class called “ShapeTest”.Define a “main()” method.Create an array of six shape...