Incorrect Syntax Near Group

[alvin567]

  $subquery = "SELECT size,CASE WHEN size <= 10 THEN CAST(size AS CHAR) WHEN size BETWEEN 11 AND 19 THEN '11-19' WHEN size BETWEEN 20 AND 40 THEN '20-40'

                    WHEN size > 40 THEN 'Over 40' END AS size_group FROM claims WHERE created BETWEEN '$startdate' and '$enddate'";

 

 

      $creationBetweenDateGroups = $this->Claim->query("SELECT practitioners,COUNT(*) AS quantity,

                                        round(COUNT(*)*100.00/(Select COUNT(*) FROM claims),2,0) WHERE created BETWEEN '$startdate' and '$enddate') AS Count

                                        FROM (".$subquery.")

                                        GROUP BY practitioners

                                        ORDER BY MAX(size) ASC;

                                        ");

 

When i run this statement it returns the results

[Barand]

You are referencing "practitioners" and "created" column from a subquery that only contains size and size_group columns.

 

Also, a table subquery needs an alias