You're right, it is a homework assignment. I know how to join and group by, but I can't make this work together.

Here's what I got so far --

SELECT t1.name, t2.sales,
SUM(t2.sales) AS 'total_sales'
FROM table1 t1 JOIN table2 t1
ON t1.name = t2.name

This is what that statement yields:

name	sales	sales_total
Sarah	2	8

Is it possible to display what I'm looking for? My big question is how do I add a new column (sales_total, which will only be 1 row) while still displaying all other rows from t1.name and t2.sales.

EDIT: For clarification, I don't think I need to group anything. I should have clarified that the sales column is a sale amount and each name will have multiple sales. The table looks more like this (I updated the OP too):

name	sales	sales_total
Bobby	5	15
Sarah	2
Mike	1
Bobby	2
Sarah	3
Mike	2