请大家帮我看下我这个SQL语句写的错误在哪里~请帮我指正下

发布网友发布时间：2023-09-29 01:36

共2个回答

热心网友时间：2024-12-14 13:50

1.select * from customer where name like '张%';
2.select count(name) from cutomer where name like '张%';
3.select count(t1.name) from customer t1 ,city t2 where t1.cityid=t2.cityid
and t2.cityname='上海';你用的子查询也可以实现
4.select count(t1.name) from customer t1 ,city t2 where t1.cityid=t2.cityid
group by t2.cityname;
希望可以帮到你，有错误请指正，谢谢追问第四句应该是错的，他的要求是找出每个城市姓张的

追答select count(t1.name) from customer t1 ,city t2 where t1.cityid=t2.cityid and t1.name like '张%'
group by t2.cityname;
不好意思，题看错了

热心网友时间：2024-12-14 13:50

select a.CityName,count(b.name) as '张姓人数' from City a,Customer b where a.CityID==b.CityID and b.name like '张%' group by a.CityName
还有你的第2、3题的语句是有问题的