Rails 24:00 Orvane Home & Outdoor

Ask

Questions are answered from the dictionary's own SQL, so a number here is the number the operator acts on. When a term has two meanings, both answers come back with how far they overlap.

How many active listings do we have?late shipments last 7 daysnet sales this weekchargebacks in the windowclean returns last 30 daysstock on hand

2,001,068 units according to the head of fulfilment (available v1).

2,001,068 units

2,001,068 units according to the head of fulfilment (available v1)

On hand minus reserved, per product and warehouse, where positive.

SQL
SELECT product_id, warehouse_id, on_hand - reserved AS units FROM stock_levels WHERE on_hand - reserved > 0

Answered with the canonical definition (available).