More SQL Please: Subqueries (Tables)

| id | product_id | quantity | date_ordered | date_arrived | |----|------------|----------|---------------------|---------------------| | 1 | 4 | 40 | 2024-11-10 03:15:40 | 2024-11-20 04:21:40 | | 2 | 1 | 20 | 2024-12-20 14:47:45 | 2025-01-01 09:37:45 | | 3 | 4 | 40 | 2024-12-20 04:18:40 | 2025-01-04 04:18:40 | | 4 | 5 | 50 | 2025-01-16 20:17:42 | 2025-01-27 08:07:47 | | 5 | 2 | 60 | 2025-02-24 01:23:38 | 2025-02-28 10:22:35 | | 6 | 3 | 60 | 2025-03-06 11:57:42 | 2025-03-08 02:22:35 | | 7 | 6 | 10 | 2025-03-12 03:18:36 | NULL | | 8 | 7 | 10 | 2025-03-15 03:22:44 | 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 |