SELECT
CASE EXTRACT( DAYOFWEEK FROM _Date)
WHEN 1 THEN 'Monday'
WHEN 2 THEN 'Tuesday'
WHEN 3 THEN 'Wednesday'
WHEN 4 THEN 'Thursday'
WHEN 5 THEN 'Friday'
WHEN 6 THEN 'Saturday'
WHEN 7 THEN 'Sunday'
END AS Day,
CAST(_Date AS VARCHAR(10) DATE FORMAT 'dd/mm/yyyy') AS Date,
_Examined AS Examined,
_Passed AS Passed,
CAST((_Passed / _Examined)*100 AS DECIMAL(6,2)) AS PassRate,
_Sent AS Sent
FROM
emStats
WHERE
_Date >= CURRENT_DATE - CAST(CAST(:DInt AS INTEGER) AS INTERVAL DAY)
ORDER BY _Date DESC