1. List reseller name for resellers who have not sold any bikes. -- 114 Rows 2. List all male customers and any clothing they have

Question

79 users unlocked this solution today!

1. List reseller name for resellers who have not sold any bikes. -- 114 Rows 

2. List all male customers and any clothing they have purchased over the internet. List customer alternate key, customer last name, customer first name, product alternate key, and product name. Be sure to include male customers who have not purchased clothing. -- 10497 Rows 

ESELECT DISTINCT R. ResellerName, R. ResellerKey, FRS. EnglishProductName FROM dbo. DimReseller AS R 1EFT OUTER JOIN (SELECT P.EnglishProductName, P.ProductSubcategoryKey, FRS. ResellerKey FROM dbo. FactResellerSales AS FRS INNER JOIN dbo. DimProduct AS P ON FRS. ProductKey P. ProductKey WHERE P.EnglishProductName = 'bike') AS FRS ON R. ResellerKey = FRS. ResellerKey WHERE R. ResellerName LIKE '%BIKE%'