How can I get a value of a column to 2 decimal points? As you can see from the columns, i wanted the output to be 2 decimal place as shown on EndOfYearForecast. Any way around it?
You can use the ROUND() function

SELECT
CONCAT("£",ROUND(SUM(cost),2)) AS EndOfYearForecast,
CONCAT("£",ROUND(SUM(cost/12),2)) AS MonthlyAverage,
CONCAT("£",ROUND(SUM(cost/53),2)) AS WeeklyAverage
FROM yearlyAnalysis;


You can also use the FORMAT() function if you want commas in the display

SELECT
CONCAT("£",FORMAT(SUM(cost),2)) AS EndOfYearForecast,
CONCAT("£",FORMAT(SUM(cost/12),2)) AS MonthlyAverage,
CONCAT("£",FORMAT(SUM(cost/53),2)) AS WeeklyAverage
FROM yearlyAnalysis;


EXAMPLE

mysql&gt; SET @NUM=1234.56789; SELECT ROUND(@NUM,2) RoundNum,FORMAT(@NUM,2) FormatNum;
Query OK, 0 rows affected (0.00 sec)

+----------+-----------+
| RoundNum | FormatNum |
+----------+-----------+
|  1234.57 | 1,234.57  |
+----------+-----------+
1 row in set (0.00 sec)

mysql&gt;