stc1473092741的博客

21. 查询所有2001~2005年入职的员工的信息，查询部门编号为20和30的员工信息并使用UNION合并 两个查询结果。#1. 查询所有记录的e_no、e_name和e_salary字段值。#23. 查询员工姓名中包含T、C或者M这3个字母中任意1个的记录。#13. 查询员工姓名以字母‘A’或‘S’开头的员工的信息。#19. 查询在BeiJing工作的员工的姓名和职务。#22. 使用LIKE查询员工姓名中包含字母a的记录。#4. 查询部门编号为20的部门中的员工信息。

SELECT s_id,f_name '价格最低的水果', MIN(f_price) FROM tb_fruits GROUP BY s_id,f_name;SELECT s_id,f_name '价格最高的水果',MAX(f_price) FROM tb_fruits GROUP BY s_id,f_name;#21、查询tb_fruits表中的f_name和f_price字段，先按f_name排序，再按f_price排序。

SELECT studentname,phone FROM tb_student WHERE gradeid=(SELECT gradeid FROM tb_grade WHERE gradename='二年级');WHERE sex = '女' AND gradeid=(SELECT gradeid FROM tb_grade WHERE gradename='一年级');and gradeid=(select gradeid from tb_grade where gradename='一年级'))

及格:>=60，中等为:70-80，优良为:80-90，优秀为:>=90。CONCAT(ROUND(SUM(IF(b.`s_score`>=70 AND b.`s_score`<80,1,0))/COUNT(b.`s_id`)*100,2),'%') AS '中等率',CONCAT(ROUND(SUM(IF(b.`s_score`>=80 AND b.`s_score`<90,1,0))/COUNT(b.`s_id`)*100,2),'%') AS '优良率',

SELECT sname FROM tb_student WHERE ssex = ANY(SELECT ssex FROM tb_student WHERE sname = '李军') AND class = ANY(SELECT class FROM tb_student WHERE sname='李军');SELECT sname AS '姓名',YEAR(CURRENT_DATE()) - YEAR(sbirthday) AS '年龄' FROM tb_student;

('804','李诚','男','1958-12-02 11:28:21','副教授','计算机系'),('831','刘冰','女','1977-08-14 00:00:00','助教','电子工程系'),('856','张旭','男','1969-03-12 00:00:00','讲师','电子工程系');('825','王萍','女','1972-05-05 00:00:00','助教','计算机系'),cno VARCHAR(20) NOT NULL COMMENT'课程编号',