Merchants have been asking Shopify to be able to create segmented automatic discounts for years; unfortunately, it’s not possible at this time using built-in automatic discounts.
Check out this thread from 2019 for the main discussion on this, which is still active in 2023: