mysql - 如何在 LEFT JOIN 条件下使用附加列

Question

我需要在我的 WHERE 条件下使用我添加的列“idade”（年龄），但是我如何使用 left 我不能在这种模式下调用该列：AND idade > 10

SQL：

SELECT 
        ins.*, count(*) as total,
        eve.eve_nome, eve.eve_tipo, 
        eve.eve_data_inicio, eve.eve_data_fim,
        TIMESTAMPDIFF(YEAR, ins.ins_data_nasc, CURDATE()) as idade
        FROM inscricoes as ins 
        LEFT JOIN eventos as  eve ON eve.eve_id=ins.eve_id
        WHERE 1=1
AND idade > 10
        GROUP BY ins.eve_id ORDER BY total DESC```

Output: 

```Column 'idade' unknow in WHERE clause```

标签： mysqlsqlphpmyadmin