More SQL Please: Subqueries (Tables)

| id | product_id | quantity | date_ordered | date_arrived | |----|------------|----------|---------------------|---------------------| | 1 | 4 | 40 | 2026-05-25 15:26:48 | 2026-06-04 16:32:48 | | 2 | 1 | 20 | 2026-07-05 02:58:53 | 2026-07-16 21:48:53 | | 3 | 4 | 40 | 2026-07-04 16:29:48 | 2026-07-19 16:29:48 | | 4 | 5 | 50 | 2026-08-01 08:28:50 | 2026-08-11 20:18:55 | | 5 | 2 | 60 | 2026-09-08 13:34:46 | 2026-09-12 22:33:43 | | 6 | 3 | 60 | 2026-09-19 00:08:50 | 2026-09-20 14:33:43 | | 7 | 6 | 10 | 2026-09-24 15:29:44 | NULL | | 8 | 7 | 10 | 2026-09-27 15:33:52 | NULL |

| id | name | category | price | remaining_stock | vendor_id | |----|--------------------------|------------|-------|-----------------|-----------| | 1 | Cool Splash Cologne | Toiletries | 49.99 | 25 | 2 | | 2 | More Spice Please Chips | Food | 3.99 | 60 | 1 | | 3 | Night Shift Coffee | Food | 6.99 | 1 | 1 | | 4 | Crunchy Munchy Trail Mix | Food | 8.99 | 5 | 3 | | 5 | Super Glide Floss | Toiletries | 1.99 | 19 | 4 | | 6 | Big Bark Dog Food | Pet Care | 30 | 2 | 2 | | 7 | Soft Purr Cat Food | Pet Care | 20 | 2 | 2 | | 8 | Tiny Fresh Scent Tree | Automotive | 2 | 7 | 4 |

| id | name | |----|-------------------------| | 1 | Quicky Express Food Co | | 2 | Good Times Distributors | | 3 | Natural Goodness | | 4 | Hyper Logistics | | 5 | Vend-tertainment |