Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

I have this script, after i run the script in sql,

/in /by

I have this script, after i run the script in sql, i am getting a
result saying that there are “no rows selected” that is not right. Please review and let me know why there are no rows selected. There should be rows selected. Question is below. Attached is the data. I need this ASAP. Thank you.
. For each Connex product compute the number of unique customers who ordered the product in Jan 2007. The results should include the product number, product name and the number of unique customers. Show results in the order of product name.

SELECT p.ProdNo, p.ProdName, COUNT(*) as “Number of Unique Customers”
FROM Product p, Customer c, Orders o, Order_Line ol
WHERE c.CustNo = o.CustNo AND p.ProdNo = ol.ProdNo AND o.OrdNo = ol.OrdNo AND
UPPER(p.ProdMfg) LIKE ‘CONNEX’ AND UPPER(substr(o.OrdDate, INSTR(o.OrdDate, ‘-‘) + 1)) LIKE ‘JAN-2007’
GROUP BY p.ProdName, p.ProdNo
ORDER BY p.ProdName;

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"