I need select sql query

Question

For example table student ... Fields stuid,name,groupid,joindate... From select query select name max count of groupid from the table... If two max count groupid is equal take the maximum join date name? I need single SQL query... can anyone help me?