orderingEmails

/*working solution*/
CREATE PROCEDURE orderingEmails()
BEGIN
    select id, email_title,
CASE
    WHEN size >= POW(2,20)
    THEN CONCAT(ROUND(FLOOR(size / POW(2,20))), ' Mb')
    ELSE CONCAT(ROUND(FLOOR(size / POW(2,10))), ' Kb')
END AS short_size FROM emails
    ORDER BY size DESC;
END