sales table by seller_id and calculate the sum of price for each group to get the total sales per seller.seller_id column for the final output, as this is the required information.erDiagram
Product {
int product_id PK
varchar product_name
int unit_price
}
Sales {
int seller_id
int product_id FK >- Product.product_id
int buyer_id
date sale_date
int quantity
int price
}