SELECT Prod_id, prod_name,TotalSalesperProduct

FROM

(

SELECT DENSE_RANK() OVER (ORDER BY SUM(s.quantity) DESC) AS Rnk,p.Prod_id, prod_name, SUM(s.quantity) AS TotalSalesperProduct

FROM Products1 p

JOIN Sales2 s ON p.Prod_id = s.prod_id

GROUP BY p.Prod_id, prod_name

)t

WHERE rnk=1

this worked.

Thanks for...

SELECT p.Prod_id, prod_name, SUM(s.quantity) TotalSalesperProduct

FROM Products1 p

JOIN Sales2 s ON p.Prod_id = s.prod_id

GROUP BY p.Prod_id, prod_name

ORDER BY TotalSalesperProduct DESC

the above works fine this brings back all products and quantities sold

when...

I am still getting the same error

FROM KEYWORD NOT FOUND WHERE EXPECTED

It may be the version I am using

It is through oracle application express I am using it

dont know if...

SELECT TOP 1 WITH TIES p.Prod_id, prod_name, SUM(s.quantity) TotalSalesperProduct

FROM Products1 p

JOIN Sales2 s ON p.Prod_id = s.prod_id

GROUP BY p.Prod_id, prod_name

ORDER BY TotalSalesperProduct DESC

I do this which looks right to me...

You have lost me now 🙁

I need a drink lol

lol thats all I can ask for

this is what I went for

SELECT p.Prod_id, prod_name, SUM(s.quantity) TotalSalesperProduct

FROM Products1 p

JOIN Sales2 s ON p.Prod_id = s.prod_id

GROUP BY p.Prod_id, prod_name

ORDER BY TotalSalesperProduct...

Hi

I am self preparing for an SQL exam and found a mock test online

I found code that worked.

select p.prod_id as product, p.prod_name as "product name", s.date_of_sale

from products1 p

left join sales67...