We''re going to switch over to the NAMES database for the next few queries.

Produce a report that shows the most popular metaphones for baby names. Include two rows

for each metaphone, one for F babies and one for M babies. For each metaphone, show the

total number of names that match that metaphone, and the total number of babies that were

given those names. Order in descending order by total number of babies, and display the

top 10 results.

Format Metaphone as 10 characters wide.

Use the all_data table

Correct results will look like this:

Gender Metaphone Total Names Total Babies

------ ---------- ----------- ---------------------------------------

M JN 35655 910583

M JMS 403 4859289

F MR 3499 4835115

M RBRT 410 4755683

M MXL 1520 4641296