Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. we continue from the two tables in lab 3 part 2, a

We continue from the two tables in lab 3 part 2, and practice with functions and...

90.2K

Verified Solution

Question

Programming

We continue from the two tables in lab3 part 2, and practice with functions and the GROUP BY statement.The data in each table should be as below

Table Product:

PROD_ID

PROD_NAME

PROD_PRICE

PROD_VENDOR

1101

Table

100

2

1102

Chair

80

3

1103

Armchair

90

2

1104

Nightstand

110

1

1105

Bed

200

3

1106

Dresser

150

3

1107

Daybed

190

2

1108

Ash Table

120

2

1109

Cherry Table

130

2

1110

Table - High

100

2

1111

Office Chair

110

3

Table Vendor:

VEND_ID

VEND_NAME

VEND_ST

1

Green Way Inc

GA

2

Forrest LLC

NC

3

AmeriMart

NC

Please write the SQL script and providescreenshots of results for thesebelow queries. Please include the SQL in textformat, and all screenshots in one singledocument.

  1. Find the total number of table products
  2. Find the average price of all tables
  3. Find the total number of products from each vendor
  4. Find the average prices by vendors (please include vendor namesin the query result)
  5. Find the average prices by states

Answer & Explanation Solved by verified expert
4.2 Ratings (675 Votes)
SQL Query 1select countProdname as number of table product fromproductwhere Prodname like Tablequery result SQL Query    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Electrical Engineering
1.2K views

List nine general firewall policies?

Advance Math
1.2K views

Problem 2-25 (Algorithmic) George Johnson recently inherited a large sum of money; he wants to use a...

Biology
1.2K views

Use the following conversions to determine atmospheric pressure in inches of mercury and millibars Round...

Physics
1.2K views

Two insulated charged spheres of radii 6 cm and 19 cm are having same charge...

Basic Math
1.2K views

The accompanying table gives domestic supply and demand schedules for a product Suppose that the...

Basic Math
1.2K views

Which equation represents the line that passes through the points (-1,-2) and (3,10)?y = 3x...

Statistics
1.2K views

100 adults and 100 teenagers were polled and asked if they liked the food choices...

Calculus
1.2K views

The region in the first quadrant between the curve y =. 2x and the curve...

Calculus
1.2K views

The equation for free fall at the surface of some planet s in meters t...

Accounting
1.2K views

Return on Assets The following financial data is from Hi-Tech Instruments' financial statements (thousands of...

Accounting
1.2K views

If a company uses the indirect method to prepare the statement of cash flows, how...

Accounting
1.2K views

Effect of Errors in Physical Inventory Fonda Motorcycle Shop sells motorcycles, ATVs, and other related...