Write a query to get the first_name, middle_name and last_name in a single column as “name”. The first name, middle_name and the last name must be separated with space.

SELECT CONCAT(first_name, ' ', middle_name, '', last_name) as name FROM `customers`;

BY Best Interview Question ON 20 Sep 2022