use cs304_db;

select dealership, sum(price)
from car_sales
group by dealership;