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 written this script but i am receiving an sql error

July 24, 2020/in Feeds /by admin

I have written this script but i am receiving an sql error such as
(Error report – SQL Error: ORA-00934: group function is not allowed here 00934. 00000 – “group function is not allowed here ) when i run the script on sql. How can i correct this ASAP.
select c.CustNo,c.CustLastName,AVG(ol.Qty) as Average ,count(o.OrdNo)
from Customer c, Orders o, Order_Line ol
where ol..OrdNo and o..CustNo and o. and o.
group by c.CustNo,c.CustLastName,AVG(ol.Qty),count(o.OrdNo)
order by Average desc;