Using AdventureWorks database and the Production schema write a common table expression that returns all rows from the table Product in the Production schema and has a Name in the ProductSubcategory table which contains 'frame'. Review the tables to determine the join condition for the tables. Run the SQL to return rows from the CTE. 

 

 

Transcribed Image Text:

USE AdventureWorks; GO EWITH FrameProduct_CTE AS ( SELECT p.* FROM Production. Product p ) JOIN Production. ProductSubcategory psc ON p.ProductSubcategoryID= psc. ProductSubcategoryID WHERE psc. Name LIKE '%frame%' SELECT * FROM FrameProduct_CTE; USE AdventureWorks; GO EWITH FrameProduct_CTE AS ( SELECT p.* FROM Production. Product p ) JOIN Production. ProductSubcategory psc ON p.ProductSubcategoryID= psc. ProductSubcategoryID WHERE psc. Name LIKE '%frame%' SELECT * FROM FrameProduct_CTE;

Answer rating: 100% (QA)

I can provide you with a SQL query to achieve this but Im unable to view images or s... View the full answer