Sales table with the Product table on product_id to get the product names for each sale.LEFT JOIN to create a result set that includes all buyers who have bought an S8, along with a list of buyers who have bought an iPhone.NULL, indicating that the buyer did not purchase an iPhone.buyer_id from the filtered result set to get the list of buyers who have bought an S8 but not an iPhone.erDiagram
Product ||--o{ Sales : contains
Product {
int product_id PK
varchar product_name
int unit_price
}
Sales {
int seller_id
int product_id FK
int buyer_id
date sale_date
int quantity
int price
}