mysql - how to increase a search variable by 1 in sql query -

The task is: Find the smallest navigator in each rating level

-

My table: Sailor (sid: Integer, Sn: String, Rating: Integer, Age: Actual) Reserve (SID: Integer, Quote: Integer, Day: Date) Boat (Quote: Anything possible:

  select min (age):   
 With novices where rating = (1 ++)  

< Pre> Select rating, SID, S from age to age (age, rating) in S (rating minimum (age), Ratings from sailor group by rating)

Edit:

Depending on the rating, you can select rating, minimum (age) from sailor group; To get the minimum age in the rating level but you will not get the details of the sailor. It is the minimum age .. .. Check where you can see that the SID is returned, the rating is 4 for 4 instead of 8 In the form of ... ... where it correctly corrects