Concatenate 3 columns and handle null values in SQL query

• Use CONCAT_WS function to concatenate columns and handle null values

• Provide a separator as the first argument in CONCAT_WS function

• Use IFNULL f...read more