I am a beginner in SQL and could really use some help.
Situation: I have a table containing the data field
(among many other data fields). I'm only concerned about those two fields. I want to select the maximum '
' for each '
'. There are only 3 possible my_location options but numerous possible my_number. All variables represented by numbers.
I was researching correlated subquery but I do not know how to use them. Maybe joins could work?
I am trying to learn different ways, effective ways to complete this task.