More SQL Please: Subqueries (Tables)

| id | product_id | quantity | date_ordered | date_arrived | |----|------------|----------|---------------------|---------------------| | 1 | 4 | 40 | 2024-12-16 05:01:05 | 2024-12-26 06:07:05 | | 2 | 1 | 20 | 2025-01-25 16:33:10 | 2025-02-06 11:23:10 | | 3 | 4 | 40 | 2025-01-25 06:04:05 | 2025-02-09 06:04:05 | | 4 | 5 | 50 | 2025-02-21 22:03:07 | 2025-03-04 09:53:12 | | 5 | 2 | 60 | 2025-04-01 03:09:03 | 2025-04-05 12:08:00 | | 6 | 3 | 60 | 2025-04-11 13:43:07 | 2025-04-13 04:08:00 | | 7 | 6 | 10 | 2025-04-17 05:04:01 | NULL | | 8 | 7 | 10 | 2025-04-20 05:08:09 | 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 |