Hoping for some help on this one as it is far to early in the morning and my brain is not in full working condition as of yet.

The following SQL statement is valid and gives the desired output, but when used in my `perl` script it returns the error below.

```
 my $stmt = 'SELECT DATE_FORMAT(completion_time, '%m') as 'month', COUNT(id) as 'total' FROM calls WHERE DATE_FORMAT(completion_time, '%Y') = ? GROUP BY DATE_FORMAT(completion_time, '%m')';
 my $sth = database->prepare($stmt);
 $sth->execute(params->{year});

```

**Error**

```
Uncaught exception from user code:
        Unmatched ) in regex; marked by <-- HERE in m/) <-- HERE  as / at /home/dev/Dancer/lib/new.pm line 507.
Compilation failed in require at ./bin/app.pl line 4.

```

I am using `Dancer` and it's Database Plugin but that is working perfectly everywhere else in the app so it is definitely an issue with my syntax or my usage of DATE\_FORMAT, but I am not sure as I have not used DATE\_FORMAT prior to today.

As always any help is appreciated and thank you in advance.