SQL语言练习参考

promote the extension of strictly administering the party grass-roots, but also the educational practice of the mass line of the party and three-three special education results achieved further inherited and expanded. To realize two a learning education is a necessary solution to the present problems of party construction. Strengthen problem consciousness and insisted on problem-oriented, is full of strictly administering the party since the partys 18 a distinctive feature, a successful experience. Secretary Wang noted that some party members still have political awareness, lack of political responsibility issues, party awareness and consciousness of the problem belief does not really believe, slim does not actually fix problems, outspoken, and jump on the assessment of the partys policies, and so on. Bi Lifu Secretary pointed out that a quarter of the economic situation is very serious, there is pressure on environment, seasonal factors and other objective reasons, but mainly subjective problem, is the problem of party members and cadres. Some depressed, negative slack, not responsible, . Double six, one, and two took the lead, build energy burst, Hongshan district, economic prosperity, eco-livable, civilized and harmonious island. It certainly can not be separated from the whole area 646 grass-roots party organizations and 14,146 members of broad participation and support. Through the two study and education, so that every cell of the party health, every organization is strong, so that all members of the vanguard and exemplary role, all the fighting bastion role of grass-roots party organizations into full play so that we can cross the Rapids, overcome all difficulties and the smooth realization of the Thirteen-Five goal. Second, basic learning, focus on learning education must understand the learning content and learning styles Foundation learning these four words are important information inside is very large, capture profound work truth in life. For example, I often say that the good Carpenter NAO Carpenter, why do some carpenters made furniture to have everybody likes it, Carpenter we are not willing to look for him? are apparently two people high and low technology, dig into the deep is firmer when both of his apprentices are not solid, there is no good that way. Luban art of story primary school are learn had, first after six mark test practice conduct, and practice cultivation, and practice perseverance, and practice patience, then with seven days seven night mill axe theory armed, and unity action, seriously learning XI General Secretary on reform development stable, and Interior diplomatic defense, and rule party ruling army of important thought, seriously learning to XI comrade for General Secretary of Central ruling acting political new concept new thought new strategy, seriously learning XI General Secretary study in Inner Mongolia important speech spirit, Guide party members and a deep understanding of a series of important speeches rich connotation and core ideas, which began so thoroughly Marxist positions To sum up, is divided into 9 main parts: 1. with regard to persisting and developing socialism with Chinese characteristics. 18 since the XIOn more than one occasion, General Secretary of the historical origin and development process of socialism with Chinese characteristics, the road of socialism with Chinese characteristics, System Info, system, uphold and develop the understanding of socialism with Chinese characteristics is determined to have been profoundly expounded, further strengthened the party and the people adhere to and develop the confidence and determination of the socialism with Chinese characteristics. XI General Secretarys speech in this regard include the peoples yearning for a better life, that is our goal, closely focus on the development of socialism with Chinese characteristics study and publicize the spirit of party 18, the unwaveringly adhere to the development of socialism with Chinese characteristics, the persistence and good use of Mao Ze-Dongs thought of soul. 2. with regard to the Chinese dream of realizing the great rejuvenation of the Chinese nation. 18 closing soon, the new Central collective leadership when they visited the exhibition of the road to recovery, XI, General Secretary of the solemn declaration the great rejuvenation of the Chinese nation, the greatest dream of the Chinese nation in modern times. Zhihou, on more than one occasion, General Secretary expounded the scientific connotation of Chinese dream, realize the Chinese dream must take the road, carry forward the spirit and cohesion of Chinese forces, gradually formed the China dream, a strategic thought. And practice with the Chinese dream, reflects the history of the new session of the CPC Central Committee, and conforms to the development trend and the people hope, embodies the greatest common divisor and the consensus of Chinese people at home and abroad, inspiring all peoples forging ahead in unity, the spirit of unswervingly follow the road of socialism with Chinese characteristics flags and high melody. This aspects XI General Secretary of speech main including achieved Chinese great revival is Chinese modern yilai most great of dream in 12th session national peoples Congress first times Conference Shang of speech work to dream into really in achieved China dream of vivid practice in the flying youth dream achieved China dream not only benefit people, and benefit world people innovation due its Shi, dream suitable have its potential achieved Chinese great revival is both at home and abroad Chinese children common of dream,. 3. on deepening reform. 18 since the XI General Secretary for the first time to Study on the choice of the Guangdong, unequivocally express the unswervingly follow the road of reform and opening up power determination and courage. Partys 18 session adopted a decision to deepen reform, opened a new journey for deepening the reform in our country. Central has held 22 times full deepening reform led Group Conference, considered through more than 100 more items important reform programme, developed introduced more than 800 over 01 操作要求操作要求 1 将文件夹将文件夹“XSGL”复制到复制到 D 盘上，并设置为默认目录。盘上，并设置为默认目录。 SET DEFA TO D:XSGL 2 打开项目打开项目“学生管理系统学生管理系统.PJX” MODIFY PROJECT 学生管理系统学生管理系统 3 打开数据库打开数据库“学生管理学生管理.DBC” 。 OPEN DATABASE 学生管理学生管理 使用使用 SQL 语句完成以下题目语句完成以下题目 4 检索检索 COURSE 表中为课程号为表中为课程号为“”“”的课程名称。的课程名称。 SELE 课程名称课程名称 FROM COURSE WHERE 课程号课程号= 5 检索检索 STUDENT 表中日语专业的学生的各项信息。表中日语专业的学生的各项信息。 SELE * FROM STUDENT WHERE 专业专业=日语日语 6 检索党员学生的学号、姓名和年龄。检索党员学生的学号、姓名和年龄。 SELE 学号学号,姓名姓名,YEAR(DATE()-YEAR(出生日期出生日期) AS 年龄年龄 FROM STUDENT WHERE 党员否党员否 7 检索计算机应用专业的学生的学号，姓名，课程号、平时成绩和期末成绩。检索计算机应用专业的学生的学号，姓名，课程号、平时成绩和期末成绩。 SELE STUDENT.学号学号,姓名姓名,课程号课程号,平时成绩平时成绩,期末成绩期末成绩 FROM STUDENT,SCORE; WHERE STUDENT.学号学号=SCORE.学号学号 AND 专业专业=计算机应用计算机应用 8 检索计算机应用专业的学生的学号，姓名，课程名称、平时成绩和期末成绩。检索计算机应用专业的学生的学号，姓名，课程名称、平时成绩和期末成绩。 SELE STUDENT.学号学号,姓名姓名,课程名称课程名称,平时成绩平时成绩,期末成绩期末成绩 FROM STUDENT,SCORE,COURSE; WHERE STUDENT.学号学号=SCORE.学号学号 AND SCORE.课程号课程号=COURSE.课程号课程号; AND 专业专业=计算机应用计算机应用 9 检索住在检索住在 201 宿舍的学生的学号和姓名。宿舍的学生的学号和姓名。 SELE 学号学号,姓名姓名 FROM STUDENT; WHERE 学号学号 IN (SELE 学号学号 FROM ROOM WHERE 房间号房间号=”201”) 10检索工商管理专业学生的住宿情况信息。检索工商管理专业学生的住宿情况信息。 SELE * FROM ROOM WHERE 学号学号 IN ; (SELE 学号学号 FROM STUDENT WHERE 专业专业=工商管理工商管理) 11检索所有选修数据库原理的学生平均期末成绩。检索所有选修数据库原理的学生平均期末成绩。 SELE AVG(期末成绩期末成绩) FROM SCORE WHERE 课程号课程号 IN; (SELE 课程号课程号 FROM COURSE WHERE 课程名称课程名称=”数据库原理数据库原理”) 12检索每个专业入学成绩高于检索每个专业入学成绩高于 520 的学生人数。的学生人数。 SELE 专业专业,COUNT(*) FROM STUDENT GROUP BY 专业专业 WHERE 入学成绩入学成绩520 13在在 COURSE 表中插入一个新的元组（，表中插入一个新的元组（，VB 程序设计，程序设计，54，3） INSERT INTO COURSE VALUE(,VB 程序设计程序设计,54,3) 14删除删除 COURSE 中目前在中目前在 SCORE 中没有任何选课记录的课程。中没有任何选课记录的课程。 DELE FROM COURSE WHERE 课程号课程号 NOT IN (SELE 课程号课程号 FROM SCORE) 15删除删除 ROOM 表中计算机应用专业学生的住宿记录。表中计算机应用专业学生的住宿记录。 DELE FROM ROOM WHERE 学号学号 IN (SELE 学号学号 FROM STUDENT WHERE 专业专业=计算机应用计算机应用) 16SCORE 中数据库原理的期末成绩均增加中数据库原理的期末成绩均增加 2 分。分。 UPDATE SCORE SET 期末成绩期末成绩=期末成绩期末成绩+2; promote the extension of strictly administering the party grass-roots, but also the educational practice of the mass line of the party and three-three special education results achieved further inherited and expanded. To realize two a learning education is a necessary solution to the present problems of party construction. Strengthen problem consciousness and insisted on problem-oriented, is full of strictly administering the party since the partys 18 a distinctive feature, a successful experience. Secretary Wang noted that some party members still have political awareness, lack of political responsibility issues, party awareness and consciousness of the problem belief does not really believe, slim does not actually fix problems, outspoken, and jump on the assessment of the partys policies, and so on. Bi Lifu Secretary pointed out that a quarter of the economic situation is very serious, there is pressure on environment, seasonal factors and other objective reasons, but mainly subjective problem, is the problem of party members and cadres. Some depressed, negative slack, not responsible, . Double six, one, and two took the lead, build energy burst, Hongshan district, economic prosperity, eco-livable, civilized and harmonious island. It certainly can not be separated from the whole area 646 grass-roots party organizations and 14,146 members of broad participation and support. Through the two study and education, so that every cell of the party health, every organization is strong, so that all members of the vanguard and exemplary role, all the fighting bastion role of grass-roots party organizations into full play so that we can cross the Rapids, overcome all difficulties and the smooth realization of the Thirteen-Five goal. Second, basic learning, focus on learning education must understand the learning content and learning styles Foundation learning these four words are important information inside is very large, capture profound work truth in life. For example, I often say that the good Carpenter NAO Carpenter, why do some carpenters made furniture to have everybody likes it, Carpenter we are not willing to look for him? are apparently two people high and low technology, dig into the deep is firmer when both of his apprentices are not solid, there is no good that way. Luban art of story primary school are learn had, first after six mark test practice conduct, and practice cultivation, and practice perseverance, and practice patience, then with seven days seven night mill axe theory armed, and unity action, seriously learning XI General Secretary on reform development stable, and Interior diplomatic defense, and rule party ruling army of important thought, seriously learning to XI comrade for General Secretary of Central ruling acting political new concept new thought new strategy, seriously learning XI General Secretary study in Inner Mongolia important speech spirit, Guide party members and a deep understanding of a series of important speeches rich connotation and core ideas, which began so thoroughly Marxist positions To sum up, is divided into 9 main parts: 1. with regard to persisting and developing socialism with Chinese characteristics. 18 since the XIOn more than one occasion, General Secretary of the historical origin and development process of socialism with Chinese characteristics, the road of socialism with Chinese characteristics, System Info, system, uphold and develop the understanding of socialism with Chinese characteristics is determined to have been profoundly expounded, further strengthened the party and the people adhere to and develop the confidence and determination of the socialism with Chinese characteristics. XI General Secretarys speech in this regard include the peoples yearning for a better life, that is our goal, closely focus on the development of socialism with Chinese characteristics study and publicize the spirit of party 18, the unwaveringly adhere to the development of socialism with Chinese characteristics, the persistence and good use of Mao Ze-Dongs thought of soul. 2. with regard to the Chinese dream of realizing the great rejuvenation of the Chinese nation. 18 closing soon, the new Central collective leadership when they visited the exhibition of the road to recovery, XI, General Secretary of the solemn declaration the great rejuvenation of the Chinese nation, the greatest dream of the Chinese nation in modern times. Zhihou, on more than one occasion, General Secretary expounded the scientific connotation of Chinese dream, realize the Chinese dream must take the road, carry forward the spirit and cohesion of Chinese forces, gradually formed the China dream, a strategic thought. And practice with the Chinese dream, reflects the history of the new session of the CPC Central Committee, and conforms to the development trend and the people hope, embodies the greatest common divisor and the consensus of Chinese people at home and abroad, inspiring all peoples forging ahead in unity, the spirit of unswervingly follow the road of socialism with Chinese characteristics flags and high melody. This aspects XI General Secretary of speech main including achieved Chinese great revival is Chinese modern yilai most great of dream in 12th session national peoples Congress first times Conference Shang of speech work to dream into really in achieved China dream of vivid practice in the flying youth dream achieved China dream not only benefit people, and benefit world people innovation due its Shi, dream suitable have its potential achieved Chinese great revival is both at home and abroad Chinese children common of dream,. 3. on deepening reform. 18 since the XI General Secretary for the first time to Study on the choice of the Guangdong, unequivocally express the unswervingly follow the road of reform and opening up power determination and courage. Partys 18 session adopted a decision to deepen reform, opened a new journey for deepening the reform in our country. Central has held 22 times full deepening reform led Group Conference, considered through more than 100 more items important reform programme, developed introduced more than 800 over WHERE 课程号课程号=(SELE 课程号课程号 FROM COURSE WHERE 课程名称课程名称=数据库原理数据库原理) 17将入学成绩最高的学生的奖学金提高将入学成绩最高的学生的奖学金提高 20%。 UPDATE STUDENT SET 奖学金奖学金=奖学金奖学金*1.2; WHERE 入学成绩入学成绩=(SELE MAX(入学成绩入学成绩) FROM STUDENT) 18关闭当前数据库；退出关闭当前数据库；退出 VFP。 CLOSE DATABASE QUIT 02 操作要求 要求： 请勿在共享文件夹中打开 XSGL 中的任一文件。若已打开，请立刻退出 VFP，或执行 CLOSE ALL 命令。 除非特别说明，本次实验题目要求使用命令完成。 尽量按顺序完成题目。在所有题目完成前，请勿执行其它操作。 文字为蓝色的题目记录到实验报告中（不需抄题，记录完整的命令即可）。 19将文件夹“05”复制到 D 盘上。并将文件夹 XSGL 设置为默认目录。 （提示：SET DEFA TO D:05XSGL） 20打开数据库“学生管理.DBC” 。 OPEN DATABASE 学生管理 21打开表“STUDENT.DBF” 。 USE STUDENT 22显示函数 BOF()、EOF()、RECNO()、RECCOUNT()的值。 ?BOF(),EOF(),RECNO(),RECCOUNT() .F.F.112 23显示 STUDENT 表中所有学生的所有信息。 LIST或DISPLAY ALL 24显示函数 BOF()、EOF()、RECNO()、RECCOUNT()的值，并与第 4 题的结果相比较。 .F.T.1312 25将记录的指针移到第一条记录，并显示此时 BOF()、EOF()和 RECNO()函数的值。 GO TOP .F.F.1 26执行 SKIP-1，显示此时 BOF()、EOF()和 RECNO()函数的值。 .T.F.1 27将记录的指针移到最后一条记录，并显示此时 BOF()、EOF()和 RECNO()函数的值。 GO BOTTOM .F.F.12 28执行 SKIP，显示此时 BOF()、EOF()和 RECNO()函数的值。 .F.T.13 29显示表中的第 5 条记录。 promote the extension of strictly administering the party grass-roots, but also the educational practice of the mass line of the party and three-three special education results achieved further inherited and expanded. To realize two a learning education is a necessary solution to the present problems of party construction. Strengthen problem consciousness and insisted on problem-oriented, is full of strictly administering the party since the partys 18 a distinctive feature, a successful experience. Secretary Wang noted that some party members still have political awareness, lack of political responsibility issues, party awareness and consciousness of the problem belief does not really believe, slim does not actually fix problems, outspoken, and jump on the assessment of the partys policies, and so on. Bi Lifu Secretary pointed out that a quarter of the economic situation is very serious, there is pressure on environment, seasonal factors and other objective reasons, but mainly subjective problem, is the problem of party members and cadres. Some depressed, negative slack, not responsible, . Double six, one, and two took the lead, build energy burst, Hongshan district, economic prosperity, eco-livable, civilized and harmonious island. It certainly can not be separated from the whole area 646 grass-roots party organizations and 14,146 members of broad participation and support. Through the two study and education, so that every cell of the party health, every organization is strong, so that all members of the vanguard and exemplary role, all the fighting bastion role of grass-roots party organizations into full play so that we can cross the Rapids, overcome all difficulties and the smooth realization of the Thirteen-Five goal. Second, basic learning, focus on learning education must understand the learning content and learning styles Foundation learning these four words are important information inside is very large, capture profound work truth in life. For example, I often say that the good Carpenter NAO Carpenter, why do some carpenters made furniture to have everybody likes it, Carpenter we are not willing to look for him? are apparently two people high and low technology, dig into the deep is firmer when both of his apprentices are not solid, there is no good that way. Luban art of story primary school are learn had, first after six mark test practice conduct, and practice cultivation, and practice perseverance, and practice patience, then with seven days seven night mill axe theory armed, and unity action, seriously learning XI General Secretary on reform development stable, and Interior diplomatic defense, and rule party ruling army of important thought