select
    store_id,
    store_name,
    product_category,
    inventory_quantity,
    sales_amount
from
    sales_inventory
    join stores using (store_id)
    join products using (product_id)
where
    inventory_quantity < 10
    and sales_amount > 5000
order by
    store_id asc,
    product_id asc;