I'm studying right now SQL and I can't solve a problem. I tried for a long time, searching on Internet and in other threads of this forum, but I haven't found nothing. So, here's my trouble:
I need to understand how to structure one kind of query. I'm gonna start with an example:
SELECT B.NAME, MAX(SUM(M.AWARD))
FROM MAILLOT M JOIN BRING B
GROUP BY B.NAME
This is wrong. And I always fail this kind of query. I mean, that kind of query when you need to know only one outcome (in this example: B.DORSAL, so the one who won the highest award) and, to do this, you use a command like MAX, COUNT, SUM, etc.
My rational logic says me every time that I shall do it as the example, but never works.
So, how that kind of querys is structured?
Thanks for the info!
And sorry for my bad english and sorry if isn't comprehensible,
I'll try to explain it again