Q: Putting in additional, temporary text for results in SQL? I'm trying to put in an additional word in a specific column of results for a query. I've got the query fine, but I can only find how to name a specific column within a table, and not the data shown within the column, and can't find the proper query online. 
I want to get the data in the column to show '50 People', instead of just '50'.
For reference this is what I've got at the moment
SELECT *
FROM SCREEN
WHERE SCREENID IN ('S1','S3')
AND BRANCHID IN ('B1','B4')
AND SCREENCAPACITY NOT LIKE '%120%'


A: Suppose Your SCREENID is 'S1', 'S3' and you want to show 'S1 Screen' and 'S3 Screen'.
SELECT CONCAT(SCREENID, ' Screen') AS RX
FROM SCREEN
WHERE SCREENID IN ('S1','S3')
AND BRANCHID IN ('B1','B4')
AND SCREENCAPACITY NOT LIKE '%120%'

