weekofyear function
Applies to: 
Databricks SQL Databricks Runtime
Returns the week of the year of expr.
weekofyear(expr)
expr: A DATE expression.
An INTEGER.
A week is considered to start on a Monday and week 1 is the first week with >3 days.
This function is a synonym for extract(WEEK FROM expr).
> SELECT weekofyear('2008-02-20');
8