|< < 43 > >|

Queries

Who ordered a Heisenberg?


select c.name
from
    customer c,
    ord o,
    item i,
    product p
where c.customer_id = o.customer_id 
and   o.ord_id = i.ord_id 
and   i.product_id = p.product_id
and   p.model_number = 'Heisenberg'

|< < 43 > >|