在mysql中选择前5名卖家

I have the follow table in MySQL

TABLE "SALES"

id, product, code, quantity, amount, who-sold-it

while the field "who-sold-it" is just a example to understand the question but not the real name of the field

Now I have another table the name is "USERS" and it looks like this

id, name, sellercode

I need to get the top 5 sellers using the 2 tables looking the who-sold-it in each SALE and display their name and sold amounts

Order the results by total sales and take the top 5 with limit. You can also join the sales table with the seller table to get the name of the seller.

select users.name, users.sellercode, sum(sales.amount) as total
from sales, users
where sales.sellercode = users.sellercode
group by users.sellercode, users.name
order by total desc
limit 5

To display the result:

<?php while ($row = mysqli_fetch_assoc($result)) ?>
    <tr>
        <td><?php echo htmlspecialchars($row['name'])</td>
        <td><?php echo htmlspecialchars($row['total'])</td>
    </tr>
<?php } ?>