denna sql-sats till mysql

query2 = "select top 10 skribent,avg(len(meddelande)) as averageLength " & _
" from forum inner join affar on forum.skribent_id = affar.medlemsid " &_
" where tecken = 'ja' " & _
" group by skribent order by 2 desc"

set rs = connect.execute(query2)
c = 0
if  not rs.eof then
response.write "De 10 som har mest tecken per inlägg: <br>"
do while not rs.eof
c = c + 1
response.write "<b><font color='#BE0202'>" & c  & ".</font></b> " & rs("skribent") & " <font color='#676767'>(" & round(rs("averageLength"),2) & " tecken" & ")</font><br>"
       
if c = 10 then exit do
rs.movenext
loop
end if

Hur skriver man så att denna SQL-sats funkar till en MySQL-databas?

query2 = "select skribent,avg(char_length(meddelande)) as averageLength " & _
" from forum inner join affar on forum.skribent_id = affar.medlemsid " &_
" where tecken = 'ja' " & _
" group by skribent order by 2 desc limit 10"