Here's how I solved it:
select concat(Name,' is from ',upper(Location),'. The ASCII character of the number ',Number,' is ',ascii(Number),'.') as Result from people;
Output:
+-------------------------------------------------------------------+
| Result |
+-------------------------------------------------------------------+
| Bond is from LONDON. The ASCII character of the number 50 is 53. |
| Tom is from IRELAND. The ASCII character of the number 100 is 49. |
+-------------------------------------------------------------------+
2 rows in set (0.00 sec)