How to calculate the week of the month?

Now we can calculate week of year, but we can’t directly calculate week of month. Is there any way?

I can use the difference between the current week and the week on the 1st of this month to calculate.

select WEEK(date '2022-5-30') - WEEK(DATE_TRUNC('month',date '2022-5-30')) + 1

@bigfacewo Currently there is no direct SQL function, tried a few ways

Using the method I proposed above can achieve the same effect.