SQL UPPER function

Question

Can you please help me? I tried everything, I don't know how to run the UPPER function

The UPPER Function

You are given the following staff table

Write a query to output the firstname and the lastname columns into one column named uppercasename separated by a space and converted to uppercase.

Answer 1

Upper(table_colomn)
Pls Post your try ,,how you are trying.. that may help to find correction...

you can use concat function to combine..

Answer 2

SELECT CONCAT (UPPER(firstname),' ',UPPER(lastname)) As uppercasename
FROM staff;

Answer 3

Thanks @Tenzing Shema, I was trying something similar but it didn't work.
I tried
SELECT CONCAT UPPER(firstname, ' ', lastname) AS uppercasename
FROM staff;
and
SELECT CONCAT (firstname, ' ', lastname) AS UPPER (uppercasename)
FROM staff;
It seems that these functions have some kind of logical hierarchy that I am not aware of. Hopefully I will gradually become aware of it.