Use single-row functions in query

/*Query 1 - Round Costs to nearest whole dollar*/
SELECT CONCAT(Signs.hor_dimens, ' ft x ', Signs.vert_dimens, ' ft') as 'Dimensions', Materials.name as 'Material', Finishes.name as 'Finish', Signs.quantity as 'Quantity', ROUND(Signs.cost) as 'Cost'
FROM Signs 
INNER JOIN Materials ON Signs.mat_id=Materials.mat_id
INNER JOIN Finishes ON Signs.finish_id=Finishes.finish_id
WHERE 1 ORDER BY cost DESC;
/*Query 2 - Change case to Upper on Text based fields*/
SELECT UPPER(CONCAT(Signs.hor_dimens, ' ft x ', Signs.vert_dimens, ' ft')) as 'Dimensions', UPPER(Materials.name) as 'Material', UPPER(Finishes.name) as 'Finish', Signs.quantity as 'Quantity', Signs.cost as 'Cost'
FROM Signs 
INNER JOIN Materials ON Signs.mat_id=Materials.mat_id
INNER JOIN Finishes ON Signs.finish_id=Finishes.finish_id;
/*Query 3 - CONCATENATE function excluding signs with power tabs or grommets*/
SELECT CONCAT(Signs.hor_dimens, ' ft x ', Signs.vert_dimens, ' ft') as '', CONCAT(Materials.name, ' with ', Finishes.name) as '' 
FROM Signs
INNER JOIN Materials ON Signs.mat_id=Materials.mat_id
INNER JOIN Finishes ON Signs.finish_id=Finishes.finish_id
WHERE Signs.finish_id!=4 and Signs.finish_id!=3;
/*Query 4 - Truncate dimensions to just 1 decimal place*/
SELECT CONCAT(TRUNCATE(Signs.hor_dimens,1), ' ft x ', TRUNCATE(Signs.vert_dimens,1), ' ft') as 'Dimensions', Materials.name as 'Material', Finishes.name as 'Finish', Signs.quantity as 'Quantity', Signs.cost as 'Cost'
FROM Signs 
INNER JOIN Materials ON Signs.mat_id=Materials.mat_id
INNER JOIN Finishes ON Signs.finish_id=Finishes.finish_id;

SELECT CONCAT(first_name, CONCAT(' ', surname)) AS name, born AS DOB
FROM people

SELECT title AS long_title, LENGTH(title) AS title_length
FROM movies
WHERE title_length > 20

SELECT UPPER(first_name)
from people

SELECT LOWER(surname)
FROM people