How to calculate the calendar week of year from a given date using the WEEKOFYEAR() function?

WEEKOFYEAR(date) is a MySQL built-in function that calculates the calendar week of year from a given date. For example:

SELECT WEEKOFYEAR('2024-03-04'), WEEK('2024-03-04', 3), WEEK('2024-03-04');
  -- +--------------------------+-----------------------+--------------------+
  -- | WEEKOFYEAR('2024-03-04') | WEEK('2024-03-04', 3) | WEEK('2024-03-04') |
  -- +--------------------------+-----------------------+--------------------+
  -- |                       10 |                    10 |                  9 |
  -- +--------------------------+-----------------------+--------------------+

Reference information of the WEEKOFYEAR() function:

WEEKOFYEAR(date): int
  Returns the calendar week of the date as a number in the range
  from 1 to 53. WEEKOFYEAR() is a compatibility function that is
  equivalent to WEEK(date,3).

Arguments, return value and availability:
  date: Required. The date to extract the calendar week of year from.
  int: Return value. The calendar week of year.
  Available since MySQL 4.

Related MySQL functions:

• WEEK() - Week of Year

⇒ YEAR() - Year of Date

⇐ WEEKDAY() - Weekday (0=Monday)

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References