Write A Query to Get First Letter Capital and rest other in lower case
Write a Query to get first letter of first_name captial and rest in lower case same with the last name and then concat this, with space in between.
SELECT
SOLUTION----
concat(concat(LEFT(first_name,1),lower(substring(first_name,2,length(first_name)))),
' ',concat(LEFT(last_name,1),lower(substring(last_name,2,length(last_name)))))
as Full_name
FROM actor