WSDBD_LAB7

select
c.customerkey, c.lastname, c.firstname, oc.channelname
from orderheader oh
right join customer c on c.customerkey = oh.customerkey
full join orderchannel oc on oc.channelkey = oh.channelkey
where oc.channelkey is null
order by 2,3

select distinct
*
from
paymentmethod pm
cross join deliverymethod dm
left join orderheader oh on oh.deliverymethodkey = dm.deliverymethodkey
and pm.paymentmethodkey = oh.paymentmethodkey
order by oh.orderkey nulls first

select distinct
*
from
paymentmethod pm
cross join deliverymethod dm
left join orderheader oh on oh.deliverymethodkey = dm.deliverymethodkey
and pm.paymentmethodkey = oh.paymentmethodkey
where oh.orderkey is null
order by oh.orderkey nulls first