Pause Break F9 F10 SysRq Name Q9: Consider the following tables. Write a query t

Question

Pause Break F9 F10 SysRq Name Q9: Consider the following tables. Write a query to list Products (ProductiD, ProductName) and the names of their Category (CategoryName), include products that do not yet have a category assigned (Where CategoryiD is null) PRODUCT Table CATEGORY Table egoryID-licate one-CategoryName ProductiD ProductName Cat Q10: A furniture store needs a database solution to support its sales and marketing analysis. Their sales and marketing department needs to look at quarterly sales data to identify top selling products and how they vary by location and across customer demographics. The sales manager typically needs such reports once or twice every qua which is typically in the millions. Discuss if a data warehouse would/would not be appropriate solution for this scenario. Provide 3 reasons in support of your recommendation.

Explanation / Answer

Please find my naswer for Q9.

Please repost others in separate post.

SELECT P.ProductID, P.ProductName, C.CategoryName
FROM Product P, Category C
WHERE P.CategoryId = C.CategoryId OR C.CategoryId is NULL

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.