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 }