This is a basic SQL question, not a Perl question. I suggest you take the time to learn basic SQL, and for that matter Perl and HTML (note you have <br> tags after <td> tags). You've been given advice already which mentions what SQL functions to read up on, I won't repeat that. I suspect you've been given this task as a learning exercise (be it in an educational establishment, or on the job training/learning), and would suggest you treat it as such.