[perl]一道作业题求帮助

[perl]一道作业题求帮助
Using a MySQL table named "user", with the columns "email" and
"create_date", go through the table and determine how many unique e-mail
addresses exist grouped by the hostname (ex: hotmail.com). Print the
results ordered by the total descending in an HTML table using
HTML::Template. Bonus: make the columns sortable. Note: use Perl for all
data processing, do not use MySQL functions or directives, only Perl code.