Which Vietnam product categories grew most in US ocean imports between 2017–18 and 2024–25?

Query

SELECT
    multiIf(
        positionCaseInsensitiveUTF8(product_desc, 'furniture') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'chair') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'sofa') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'table') > 0, 'Furniture',
        positionCaseInsensitiveUTF8(product_desc, 'electronic') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'circuit') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'semiconductor') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'display') > 0, 'Electronics',
        positionCaseInsensitiveUTF8(product_desc, 'garment') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'apparel') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'clothing') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'textile') > 0, 'Apparel/Textile',
        positionCaseInsensitiveUTF8(product_desc, 'shoe') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'footwear') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'sneaker') > 0, 'Footwear',
        positionCaseInsensitiveUTF8(product_desc, 'tire') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'tyre') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'rubber') > 0, 'Tires/Rubber',
        positionCaseInsensitiveUTF8(product_desc, 'solar') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'panel') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'photovoltaic') > 0, 'Solar Panels',
        positionCaseInsensitiveUTF8(product_desc, 'seafood') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'shrimp') > 0 OR positionCaseInsensitiveUTF8(product_desc, 'fish') > 0, 'Seafood',
        'Other'
    ) AS category,
    uniqExactIf(bill_of_lading, toYear(actual_arrival_date) IN (2017, 2018)) AS bols_2017_18,
    uniqExactIf(bill_of_lading, toYear(actual_arrival_date) IN (2024, 2025)) AS bols_2024_25
FROM bols
WHERE actual_arrival_date >= toDate('2017-01-01')
  AND actual_arrival_date <= toDate('2025-12-31')
  AND (match(upperUTF8(country), 'VIET|VIETNAM') OR match(upperUTF8(loading_port), 'HO CHI MINH|HAI PHONG|HAIPHONG|DA NANG'))
  AND weight_in_kg > 1000
GROUP BY category
ORDER BY bols_2024_25 DESC