在store库内你想找到没有被订购过的商品
    SELECT
    FROM products
    WHERE product_id *NOT IN     (
    SELECT DISTINCT product_id
    FROM order_items
    )

    SELECT

    FROM clients
    WHERE client_id *NOT IN     (
    SELECT DISTINCT client_id
    FROM invoices
    )