如下两张表, name_t 和 age_t: name_t ...
发布于 2022-03-03 16:57:50
如下两张表, name_t 和 age_t:
name_t
ID | Name |
1 | Nick |
2 | Tom |
3 | John |
4 | Peter |
5 | Frank |
age_t
ID | Age |
1 | 18 |
2 | null |
3 | 35 |
5 | 22 |
结合表信息,写出sql的最终结果()
SELECT count(t1.ID) as cnt FROM name_t t1 LEFT JOIN age_t t2 ON t1.ID = t2.ID WHERE t2.Age > 22
关注者
0
被浏览
22