Question

Which type of query is best suited for an outer join using two tables named "Products Offered" and "Cost of

Products"?
one that should show all products offered by a company
one that should show only products that cost over $20
one that should show all duplicate products sold in a month
one that should show only prices of $20 that have products attached
c

Answer 1

select WorkCenterId, Count (ProducedIn_t.ProductID) as 'TotalProducts' from ProducedIn_t left outer join Product_t on Product_t.ProductID=Product_t.ProductID group by WorkCenterId