MrTV
asked on
find the summation of maximum product of each team sale postgresql
how an I find the summation of maximum product each team sale in PostgreSQL
team produ sale
a coke 100
a coke 25
a pepsi 200
a pepsi 50
b fanta 400
b coke 27
b coke 50
c coke 20
c coke 20
c fanta 20
the result is
team maxproduct totalsellmaxproduct
a pepsi 250
b fanta 400
c coke 40
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.