CODE EXAMPLE FOR SQL

is not null sql

select c_custkey, c_name, c_address from customer where c_custkey in (select o_orderkey from orders where o_orderkey IS NOT NULL)