In SQL For the products that are finished goods, find a product Categories with average price above
Fantastic news! We've Found the answer you've been seeking!
Question:
In SQL For the products that are finished goods, find a product Categories with average price above 200$ You need to use three tables: Product, ProductSubcategory and Product Category
Product table contains price and subcategory, you can join it to ProductSubcategory table to get the ProductCategoryID and finally join to Product category table to get the Category description.
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-0078025655
7th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Old
Posted Date: