What is the return type of the dayofweek() function in Databricks SQL and what day does it consider as the first day of the week?
The `dayofweek()` function in Databricks SQL returns an INTEGER value where 1 represents Sunday and 7 represents Saturday. Therefore, the first day of the week is considered to be Sunday.