Question: MBPH...- dbo.Diagram_2 USE AdventureWorks2012; SQL Queryl.sql - D...3MBPHRWard (51))* Assignment06.sql - not connected* + x You are required to use INNER JOINS to solve each

MBPH...- dbo.Diagram_2 USE AdventureWorks2012; SQL Queryl.sql - D...3MBPH\RWard (51))* Assignment06.sql - not connected* + x You are required to use INNER JOINS to solve each problem. We are not using cross joins with WHERE clauses. To make the joins in the first 4 question more understandable, create a database diagram with the following tables: --Production. Product --Production.ProductReview --Production. ProductModel --Production. ProductSubcategory --Production.ProductCategory -1.a. List any products that have product reviews. Show product ID, product name, and comments. Hint: Use the Production. Product and Production.ProductReview tables. (1 points) 4 Rows 1.b. Modify 1.a. to list product reviews for Product ID 798. Show product ID, product name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
