How many products were not included in any order?
create table products (product_id varchar, PRIMARY KEY (product_id)); create table order_items (product_id varchar, PRIMARY KEY (product_id))
select count(*) from products where not product_id in (select product_id from order_items)