• + 1 comment

    Okay found the problem. I needed the 's.' in the end of CONCAT

    CONCAT('There are a total of ', COUNT(occupation), ' ', occupation, 's.')