qq名字网——Dont kick balls on the road, boys !——Sorry ,_____.
- A. we will B. we shall C. we wont D. we arent 答案是C ，为什么？求解释。
- C.We wontwe wont =we wont kick balls on the road.意思是“（好）我们不会踢了。”
SQL数据库语句 求帮忙检查
- Create Datebase AnswerUse AnswerGo2. Create Table Players(PNO char(2) Primary key,PName char(20),PBirthday date CHECK(PBirthday’1985-1-1’ and PBirthday’1993-12-31’),Pcity char(20) Default‘上海’ ,Telephone char(20));Create Table Balls(PNO char(2) Primary key,Cdate date NOT NULL,EBalls integer NOT NULL,FOREIGN KEY(PNO)references Players(PNO));3. Update Players SET PNO =’20’where PName=’孙鑫’;4. Delete From Balls where PNO in(SELECTPNO FROM Players where PName=’姚爽’);5. SELECT PNO,SUM(EBalls) FromBalls GROUP BY PNO ORDER BY SUM(EBalls) DESC;6. SELECT PNO,PNAME,PBirthday,PCity,TelephoneFROM Players where PBirthday1990-1-1 and PName like ‘%兵%’;7. Create view v1As SELECT PNO,PName,PBirthday,Telephone,Cdate,EBalls FROMPlayers,Balls Where Players.PNO= Balls.PNO8. Update Players SET Telephone = ‘010-’+ Telephone where PCity = ‘北京’;9. SELECTPName,PCity,PBirthday,Telephone,Cdate,COUNT(EBalls) From Players,Balls Where Players.PNO=Balls.PNOand PName like ‘孙%’ Group by PNO Order by PNO ASC,COUNT(EBalls) DESC ;10. ΠPName,PBirthday,Cdate,EBalls(σPCity=’广州’(Players Balls))由于本人基础实在太差，可能有各种错误，麻烦完整看下可私信564643626@qq.com今天内要解决
- 没发现问题，除了语句要写标准，比如说from 表中间有空格，and 前后面都有空格，10. ΠPName,PBirthday,Cdate,EBalls(σPCity=’广州’(Players Balls))不知道是什么意思
