select
    st.store_id,
    st.store_name,
    p.product_category,
    si.inventory_quantity,
    si.sales_amount
from
    sales_inventory si 
    join products p on si.product_id = p.product_id
    join stores st on si.store_id = st.store_id
where
    si.inventory_quantity < 10 and
    si.sales_amount > 5000
order by
    st.store_id,
    p.product_id