答案是:
1 SELECT ANO,ANAME,ATEAM FROM ATHLETE WHERE EXISTS (SELECT * FROM GAMES WHERE GAMES.ANO=ATHLETE.ANO AND INO=’100035’)2 CREATE VIEW V_GAMES_G(ANO,AVG(SCORE))AS (SELECT ANO,AVG(SCORE) FROM GAMES GEOUP BY ANO)
出自
联大 >
郑州工业应用技术学院VFP数据库
更多答案联系客服:19139051760
本题添加时间:2023/4/3 12:59:00