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;
原文：https://www.cnblogs.com/niuli1987/p/9696048.html