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. 

 

 

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;