sql - 如何在查询中使用 "case when"

Question

我有这个查询:

 $em = $this->getDoctrine()->getEntityManager();
$query = $em->createQuery("SELECT u,COUNT(u) AS nb_renouvellement,
    SUM(CASE WHEN f.`Criticity` = 'M' THEN 1 ELSE 0 END)  nb_majeur,
    SUM(CASE WHEN f.`Criticity` = 'C' THEN 1 ELSE 0 END)  nb_critique
    FROM AdminBlogBundle:AlertesBss2  f
GROUP BY f.BSC");
$listes = $query->getResult();

但我有这个错误

[Syntax Error] line 0, col 45: Error: Expected Literal, got 'CASE'

Answer 1

批评不应该用引号引起来，它应该由 f.u 分组