gistfile1.txt

[1]
SELECT count(DISTINCT salesDate), productID FROM basket_product GROUP BY productID order by count(DISTINCT salesDate) DESC

[1] MAIN (a)
SELECT product.productID, product.productDesc, SUM(basket_product.salesPrice*basket_product.salesQty), count(DISTINCT salesDate) FROM basket_product, product WHERE basket_product.productID = product.productID GROUP BY product.productID order by SUM(basket_product.salesPrice*basket_product.salesQty) desc, count(DISTINCT salesDate) DESC

[1] MAIN (b)
SELECT COUNT(DISTINCT salesDate) FROM basket_product

[2] (a)
SELECT SUM(salesQty*salesPrice) AS 'REVENUE', majorcategory.majorcategoryDesc FROM basket_product, product, segment, subcategory, category, majorcategory WHERE basket_product.productID = product.productID AND product.segmentID = segment.segmentID AND segment.subcategoryID = subcategory.subcategoryID AND subcategory.categoryID = category.categoryID AND category.majorcategoryID = majorcategory.majorcategoryID group by majorcategory.majorcategoryID order by SUM(salesQty*salesPrice) DESC

[2] (b)
SELECT SUM(salesQty*salesPrice) AS 'REVENUE', subcategory.subcategoryDesc FROM basket_product, product, segment, subcategory, category, majorcategory WHERE basket_product.productID = product.productID AND product.segmentID = segment.segmentID AND segment.subcategoryID = subcategory.subcategoryID AND subcategory.categoryID = category.categoryID AND category.majorcategoryID = majorcategory.majorcategoryID AND majorcategory.majorcategoryDesc = 'PHOTO' group by subcategory.subcategoryID order by SUM(salesQty*salesPrice) DESC

[3] 
SELECT COUNT(*), pharmacyState FROM pharmacy group by pharmacyState order by count(*) desc


SELECT COUNT(*) FROM category, product, segment, subcategory where product.segmentID = segment.segmentID AND segment.subcategoryID = subcategory.subcategoryID AND subcategory.categoryID = category.categoryID AND catDesc LIKE '%pain%'
UNION
SELECT COUNT(*) FROM category, product, segment, subcategory where product.segmentID = segment.segmentID AND segment.subcategoryID = subcategory.subcategoryID AND subcategory.categoryID = category.categoryID AND catDesc LIKE '%digest%'
UNION
SELECT COUNT(*) FROM category, product, segment, subcategory where product.segmentID = segment.segmentID AND segment.subcategoryID = subcategory.subcategoryID AND subcategory.categoryID = category.categoryID AND catDesc LIKE '%cold%'
UNION
SELECT COUNT(*) FROM category, product, segment, subcategory where product.segmentID = segment.segmentID AND segment.subcategoryID = subcategory.subcategoryID AND subcategory.categoryID = category.categoryID AND catDesc LIKE '%eye%'
UNION
SELECT COUNT(*) FROM category, product, segment, subcategory where product.segmentID = segment.segmentID AND segment.subcategoryID = subcategory.subcategoryID AND subcategory.categoryID = category.categoryID AND catDesc LIKE '%vitam%'