=== Report 1: Merchant size and recent growth trend (written by Bea) === Engineer's note: Revenue is converted to EUR using the daily exchange_rates (EUR base) matched to each order's placed_at date. Growth pct is left NULL (rather than a misleading number) for merchants with zero prior-period orders/revenue, since growth is undefined in that case. All 120 merchants fit within the 50-row cap only if there are ≤50 tenants with last-90-day revenue; the report notes total row count as usual. REPORT: Merchant size and recent growth trend QUESTION: How big is each merchant's business on Tidewick, and is it growing, flat, or shrinking over the last quarter? merchant_name | industry | employee_count | orders_last_90_days | gross_revenue_eur_last_90_days | orders_prior_90_days | gross_revenue_eur_prior_90_days | revenue_growth_pct | order_growth_pct -----------------------+---------------------------+----------------+---------------------+--------------------------------+----------------------+---------------------------------+--------------------+----------------- Cragsley Outfitters | Apparel & Footwear | 2819 | 1369 | 301430.02395766746 | 706 | 122187.0634238108 | 146.7 | 93.9 Marrowby & Vane | Apparel & Footwear | 1179 | 626 | 114712.3236751873 | 336 | 47000.99021992728 | 144.1 | 86.3 OfficeHub Nordic | Office Supplies (B2B) | 126 | 54 | 95374.2646994069 | 41 | 72913.64427392166 | 30.8 | 31.7 Castell Fasteners | Industrial Supplies (B2B) | 82 | 40 | 89765.90754690344 | 36 | 93205.49476782502 | -3.7 | 11.1 Deskline Supplies | Office Supplies (B2B) | 52 | 23 | 49519.31307200409 | 17 | 47289.4098396427 | 4.7 | 35.3 Cinder Peak Sports Co. | Sports & Outdoor | 285 | 103 | 37423.0352890475 | 68 | 28439.879243113093 | 31.6 | 51.5 Fennel & Flint | Home & Living | 458 | 169 | 29357.02255675589 | 73 | 12194.426023545255 | 140.7 | 131.5 Petalcourt Beauty | Beauty | 337 | 239 | 19776.8370108967 | 155 | 15108.667124507807 | 30.9 | 54.2 Oakhurst Tailoring | Apparel & Footwear | 100 | 80 | 13578.429230015927 | 33 | 3619.9249782614993 | 275.1 | 142.4 Velvet Ash | Apparel & Footwear | 118 | 50 | 11099.06167869471 | 27 | 3912.1627442057597 | 183.7 | 85.2 Coastline Interiors | Home & Living | 69 | 65 | 8889.546606660853 | 23 | 2324.1359313613752 | 282.5 | 182.6 Bytefield | Consumer Electronics | 27 | 11 | 8534.818988547484 | 4 | 858.043142905524 | 894.7 | 175.0 Grind Collective | Food & Coffee | 190 | 339 | 7947.597909435651 | 268 | 4136.836648958326 | 92.1 | 26.5 Kibblewick | Pet Supplies | 242 | 194 | 6937.270312135312 | 154 | 5017.189964799554 | 38.3 | 26.0 Honeycomb Larder | Food & Coffee | 115 | 181 | 6703.36853441957 | 147 | 2983.617249584439 | 124.7 | 23.1 Kayak Corner | Sports & Outdoor | 89 | 19 | 6649.09037425596 | 22 | 5698.812626069689 | 16.7 | -13.6 Thistlecombe | Apparel & Footwear | 219 | 42 | 6586.155813760571 | 22 | 2240.9411708216 | 193.9 | 90.9 Juniper Apothecary | Beauty | 47 | 55 | 6143.895316009281 | 28 | 2984.6348948428586 | 105.9 | 96.4 Fell & Fjell | Sports & Outdoor | 84 | 17 | 5888.326844261869 | 20 | 14457.708191981035 | -59.3 | -15.0 Willow & Wren | Home & Living | 63 | 32 | 5462.010944554868 | 15 | 3648.685534007297 | 49.7 | 113.3 Nordic Bloom Cosmetics | Beauty | 73 | 43 | 4994.887512606441 | 33 | 4022.840973087755 | 24.2 | 30.3 The Balm Room | Beauty | 42 | 38 | 3782.2293516296427 | 22 | 3251.671965642071 | 16.3 | 72.7 Saffron & Sage | Beauty | 42 | 43 | 3591.168799499806 | 23 | 1065.8788914490021 | 236.9 | 87.0 Fjordline Wear | Apparel & Footwear | 27 | 22 | 2861.0910292157914 | 6 | 906.7772278184029 | 215.5 | 266.7 Tail Wag Supply | Pet Supplies | 48 | 29 | 2525.1108895814386 | 23 | 1403.0558200963414 | 80.0 | 26.1 Alpine Loft | Sports & Outdoor | 28 | 2 | 2430.368817325345 | 0 | 0.0 | NULL | NULL Circuit Harbor | Consumer Electronics | 62 | 5 | 2360.257771442038 | 4 | 6336.198469745448 | -62.7 | 25.0 Courtside Collective | Sports & Outdoor | 34 | 5 | 2359.677594562969 | 5 | 799.7392947658468 | 195.1 | 0.0 Feather & Fin | Pet Supplies | 58 | 73 | 2338.433247997085 | 49 | 1801.6730068517322 | 29.8 | 49.0 Lamplight Living | Home & Living | 61 | 18 | 2319.5457051203916 | 16 | 1948.8052151719758 | 19.0 | 12.5 Greyfriars Supply | Apparel & Footwear | 37 | 8 | 2275.185355913487 | 3 | 258.69262579825624 | 779.5 | 166.7 Roast Republic | Food & Coffee | 49 | 21 | 1821.8625445112848 | 7 | 836.2226695519022 | 117.9 | 200.0 Meadow Row | Apparel & Footwear | 36 | 4 | 1641.062136570437 | 6 | 2980.3147745527444 | -44.9 | -33.3 Driftwood Home | Home & Living | 32 | 9 | 1551.6115265956932 | 6 | 702.8960817586639 | 120.7 | 50.0 Hus & Hem | Home & Living | 82 | 13 | 1488.767642017202 | 7 | 1229.1030692822321 | 21.1 | 85.7 Signalbox | Consumer Electronics | 18 | 5 | 1439.8531421743749 | 0 | 0.0 | NULL | NULL Rosehip Lab | Beauty | 37 | 16 | 1404.46589152984 | 6 | 836.0861158521654 | 68.0 | 166.7 Stoneware Studio | Home & Living | 61 | 12 | 1318.165175964863 | 3 | 421.2215403158874 | 212.9 | 300.0 Tiny Atelier | Home & Living | 37 | 8 | 1283.8234387644463 | 4 | 367.2338405621915 | 249.6 | 100.0 Brick & Bobbin | Apparel & Footwear | 26 | 10 | 1224.3079174304328 | 3 | 354.30285126178313 | 245.6 | 233.3 Glasshouse Grooming | Beauty | 26 | 8 | 1207.690922367792 | 1 | 189.77029350092164 | 536.4 | 700.0 Haven Linen | Home & Living | 27 | 6 | 1106.5250278681465 | 7 | 1305.2868027404634 | -15.2 | -14.3 Silverthread | Jewelry & Accessories | 23 | 6 | 1029.6122237688733 | 1 | 474.09138186513644 | 117.2 | 500.0 Little Larch Kids | Apparel & Footwear | 34 | 7 | 1020.6475252913605 | 5 | 727.3425053315126 | 40.3 | 40.0 Copper Lane | Apparel & Footwear | 27 | 6 | 1003.558542492167 | 0 | 0.0 | NULL | NULL Folio & Fern | Books & Stationery | 59 | 21 | 941.9638270295954 | 7 | 387.51536783447614 | 143.1 | 200.0 Purrfect Pantry | Pet Supplies | 21 | 16 | 729.9469149071315 | 14 | 930.1868444290354 | -21.5 | 14.3 Barkley & Co. | Pet Supplies | 32 | 8 | 683.967507187761 | 8 | 825.7022537205145 | -17.2 | 0.0 Paperplane Press | Books & Stationery | 54 | 14 | 655.2004234205338 | 6 | 328.01538915329314 | 99.7 | 133.3 Kibble Crate | Pet Supplies | 29 | 6 | 415.0594406179933 | 5 | 406.16977822443664 | 2.2 | 20.0 (50 rows)