Follow the table - https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-datatype-rules#type-precedence-list
