MySQL 报错

SELECT COUNT(1) FROM
(select tid from teacher where tname like '李%')

1248 - Every derived table must have its own alias, Time: 0.000000s

要给子查询的表 加一个伪名

SELECT COUNT(1) FROM
(select tid from teacher where tname like '李%') as fuck;