MySQL练习二

一、job表

-- 1、查询与“罗曼”求职同一职位的还有哪些人
SELECT*
FROM job
WHERE job.position = (SELECT job.position FROM job WHERE job.`name` = '罗曼')

-- 2、查询哪些求职者的年龄高于所有求职者的平均年龄
SELECT *
FROM job
WHERE job.age > (SELECT AVG(job.age) FROM job)
-- 3、查询最受欢迎的职位有哪些求职者感兴趣
--思路："最受欢迎职位"，就是count(职位)数量最多的那个职位
SELECT * 
FROM job
WHERE job.position = 
(SELECT job.position
FROM job
GROUP BY job.position
ORDER BY COUNT(job.position) DESC
LIMIT 1)
-- 4、查询与“王亮”同一天面试的还有哪些人
SELECT *
FROM job
WHERE job.recDate = (SELECT job.recDate FROM job WHERE job.`name` = '王亮')

-- 5、查询哪些职位比“网络推广”职位更受欢迎
SELECT job.position AS 职位 FROM job GROUP BY job.position HAVING COUNT(*) > (SELECT COUNT(*)
FROM job
WHERE job.position = '网络推广')

job表sql文：

/*
 Navicat Premium Data Transfer

 Source Server         : my_project
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : mysql_test

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 01/05/2022 10:52:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for job
-- ----------------------------
DROP TABLE IF EXISTS `job`;
CREATE TABLE `job`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `recDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `age` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of job
-- ----------------------------
INSERT INTO `job` VALUES ('1', '2010-06-05', '联合路招聘会', '美工', '郭林', '18', NULL, '女');
INSERT INTO `job` VALUES ('2', '2010-06-05', '联合路招聘会', '美工', '吕蕊', '19', NULL, '女');
INSERT INTO `job` VALUES ('3', '2010-06-06', '智联招聘', '咨询顾问', '李春林', '24', '15542328201', '男');
INSERT INTO `job` VALUES ('4', '2010-06-06', '智联招聘', '咨询顾问', '张洁', '21', '13889576862', '女');
INSERT INTO `job` VALUES ('5', '2010-06-09', '智联招聘', '美工', '商颖', '22', '15998444013', '女');
INSERT INTO `job` VALUES ('6', '2010-06-09', '智联招聘', '美工', '谷盛坤', '23', '1347878568', '男');
INSERT INTO `job` VALUES ('7', '2010-06-09', '智联招聘', '咨询顾问', '张海玲', '20', '15942831676', '女');
INSERT INTO `job` VALUES ('8', '2010-06-09', '智联招聘', '咨询顾问', '刘洪娟', '25', '13504243406', '女');
INSERT INTO `job` VALUES ('9', '2010-06-09', '大连快线', '咨询顾问', '罗曼', '20', '13478053587', '女');
INSERT INTO `job` VALUES ('10', '2010-06-09', '大连快线', '咨询顾问', '张瑜', '27', '13591381400', '女');
INSERT INTO `job` VALUES ('11', '2010-06-09', '大连快线', '咨询顾问', '田雯', '28', '13644089215', '女');
INSERT INTO `job` VALUES ('12', '2010-06-09', '大连快线', '咨询顾问', '徐小凤', '29', '13898417166', '女');
INSERT INTO `job` VALUES ('13', '2010-06-09', '大连快线', '咨询顾问', '王亚丽', '34', '13842880114', '女');
INSERT INTO `job` VALUES ('14', '2010-06-09', '大连快线', '咨询顾问', '孙正旭', '18', '13840840128', '女');
INSERT INTO `job` VALUES ('15', '2010-06-09', '大连快线', '咨询顾问', '郑佳', '19', '18841180703', '女');
INSERT INTO `job` VALUES ('16', '2010-06-09', '大连快线', '咨询顾问', '贾迪', '24', '13238035341', '女');
INSERT INTO `job` VALUES ('17', '2010-06-09', '大连快线', '咨询顾问', '李双凤', '21', '18940933675', '女');
INSERT INTO `job` VALUES ('18', '2010-06-09', '大连快线', '咨询顾问', '朱琳', '22', '13591106279', '女');
INSERT INTO `job` VALUES ('19', '2010-06-09', '大连快线', '咨询顾问', '刘晓矫', '23', '15942885283', '女');
INSERT INTO `job` VALUES ('20', '2010-06-09', '大连快线', '咨询顾问', '李雪', '20', '13998497747', '女');
INSERT INTO `job` VALUES ('21', '2010-06-09', '联合路招聘会', '美工', '郭蕾', '25', '15898103121', '女');
INSERT INTO `job` VALUES ('22', '2010-06-09', '联合路招聘会', '美工', '陈磊', '20', '13840859384', '女');
INSERT INTO `job` VALUES ('23', '2010-06-09', '面试人员介绍的', '实习生', '康翰杰', '27', '15942845427', '男');
INSERT INTO `job` VALUES ('24', '2010-06-09', '联合路招聘会', '实习生', '王亮', '28', '15142479557', '男');
INSERT INTO `job` VALUES ('25', '2010-06-09', '联合路招聘会', '实习生', '周振鑫', '29', '15840947274', '男');
INSERT INTO `job` VALUES ('26', '2010-06-09', '联合路招聘会', '实习生', '李臻', '34', '15041171092', '男');
INSERT INTO `job` VALUES ('27', '2010-06-09', '联合路招聘会', '实习生', '郭俊', '18', '13516050364', '男');
INSERT INTO `job` VALUES ('28', '2010-06-09', '联合路招聘会', '实习生', '赵广月', '19', '15640875342', '男');
INSERT INTO `job` VALUES ('29', '2010-06-10', '大连快线', '实习生', '王赞', '24', '13052758969', '男');
INSERT INTO `job` VALUES ('30', '2010-06-10', '智联招聘', '咨询顾问', '李冰冰', '21', '13624248003', '女');
INSERT INTO `job` VALUES ('31', '2010-06-10', '智联招聘', '咨询顾问', '张海玲', '22', '15942831676', '女');
INSERT INTO `job` VALUES ('32', '2010-06-10', '智联招聘', '市场专员', '王世葆', '23', '15942878932', '男');
INSERT INTO `job` VALUES ('33', '2010-06-10', '智联招聘', 'PHP实习生', '李小双', '20', '13840937202', '男');
INSERT INTO `job` VALUES ('34', '2010-06-10', '智联招聘', 'PHP实习生', '刘金明', '25', '15242560161', '男');
INSERT INTO `job` VALUES ('35', '2010-06-10', '智联招聘', 'PHP实习生', '刘云超', '20', '15840660540', '男');
INSERT INTO `job` VALUES ('36', '2010-06-11', '智联招聘', '市场专员', '陈悦', '27', '13591359794', '女');
INSERT INTO `job` VALUES ('37', '2010-06-11', '智联招聘', '咨询顾问', '肖俊丽', '28', '15140488064', '女');
INSERT INTO `job` VALUES ('38', '2010-06-12', '智联招聘', '咨询顾问', '张丽洪', '29', '15840652431', '女');
INSERT INTO `job` VALUES ('39', '2010-06-12', '智联招聘', '市场专员', '宋广双', '34', '15998608955', '女');
INSERT INTO `job` VALUES ('40', '2010-06-12', '智联招聘', '校园代理', '于岑旸', '18', '15040463283', '女');
INSERT INTO `job` VALUES ('41', '2010-06-13', '智联招聘', '网站前台', '彭超', '19', '13889458046', '男');
INSERT INTO `job` VALUES ('42', '2010-06-13', '智联招聘', '实习生', '陶学辉', '24', '15041175784', '男');
INSERT INTO `job` VALUES ('43', '2010-06-13', '大连人才', '实习生', '赵永亮', '21', '15998609205', '男');
INSERT INTO `job` VALUES ('44', '2010-06-17', '51job', 'java实习生', '孙磊', '22', '13889662403', '男');
INSERT INTO `job` VALUES ('45', '2010-06-17', '51job', 'IT实习生', '吴秀丽', '23', '15809667752', '女');
INSERT INTO `job` VALUES ('46', '2010-06-17', '51job', 'IT实习生', '张弓', '20', '13610910266', '男');
INSERT INTO `job` VALUES ('47', '2010-06-17', '51job', 'IT实习生', '李宗霖', '25', '15942679157', '男');
INSERT INTO `job` VALUES ('48', '2010-06-17', '51job', 'IT实习生', '董妍', '20', '13610910262', '女');
INSERT INTO `job` VALUES ('49', '2010-06-17', '51job', 'IT实习生', '邓荣盛', '27', '13654208978', '男');
INSERT INTO `job` VALUES ('50', '2010-06-17', '51job', 'IT实习生', '张琦', '28', '15201406612', '女');
INSERT INTO `job` VALUES ('51', '2010-06-17', '51job', '市场专员', '刘敏', '29', '15242530372', '女');
INSERT INTO `job` VALUES ('52', '2010-06-17', '51job', '市场专员', '刘慧鑫', '34', '13664205423', '女');
INSERT INTO `job` VALUES ('53', '2010-06-17', '51job', 'IT实习生', '杨远景', '18', '15998636591', '男');
INSERT INTO `job` VALUES ('54', '2010-06-17', '51job', '市场专员', '邱艳', '19', '15042498532', '女');
INSERT INTO `job` VALUES ('55', '2010-06-17', '51job', '咨询师', '鲁雯雯', '24', '15840926512', '女');
INSERT INTO `job` VALUES ('56', '2010-06-17', '51job', 'IT实习生', '詹嵩南', '21', '13485915677', '男');
INSERT INTO `job` VALUES ('57', '2010-06-17', '51job', '市场专员', '张波', '22', '13664246303', '女');
INSERT INTO `job` VALUES ('58', '2010-06-17', '51job', 'IT实习生', '翟伟静', '23', '15145102611', '女');
INSERT INTO `job` VALUES ('59', '2010-06-17', '51job', '市场专员', '周广慧', '20', '15842625692', '男');
INSERT INTO `job` VALUES ('60', '2010-06-17', '51job', 'IT实习生', '刘紫寒', '25', '13610846177', '男');
INSERT INTO `job` VALUES ('61', '2010-06-17', '51job', '咨询师', '李娇妍', '20', '13050557447', '女');
INSERT INTO `job` VALUES ('62', '2010-06-17', '大连快线', '市场专员', '王士豪', '27', '15132200004', '男');
INSERT INTO `job` VALUES ('63', '2010-06-17', '大连快线', '市场专员', '翁嫱', '28', '15998505313', '女');
INSERT INTO `job` VALUES ('64', '2010-06-17', '智联招聘', '网站美工', '张梦婷', '29', '15010298860', '女');
INSERT INTO `job` VALUES ('65', '2010-06-17', '智联招聘', '咨询师', '韩娜', '34', '18941196967/15998422452 ', '女');
INSERT INTO `job` VALUES ('66', '2010-06-17', '智联招聘', '咨询师', '沈佳', '18', '13889487313', '男');
INSERT INTO `job` VALUES ('67', '2010-06-17', '智联招聘', '咨询师', '单君梅', '19', '13604259529', '女');
INSERT INTO `job` VALUES ('68', '2010-06-17', '智联招聘', '咨询师', '胡俊伟', '24', '13889586097', '女');
INSERT INTO `job` VALUES ('69', '2010-06-17', '智联招聘', '网站美工', '姚媛', '21', '15140390512', '女');
INSERT INTO `job` VALUES ('70', '2010-06-17', '智联招聘', '市场专员', '王金刚', '22', '13889590243', '男');
INSERT INTO `job` VALUES ('71', '2010-06-17', '智联招聘', '咨询师', '郑聪', '23', '15840650933', '女');
INSERT INTO `job` VALUES ('72', '2010-06-17', '智联招聘', '市场专员', '薛振红', '20', '15998448241', '男');
INSERT INTO `job` VALUES ('73', '2010-06-17', '智联招聘', '市场专员', '韩继水', '25', '15942875180', '男');
INSERT INTO `job` VALUES ('74', '2010-06-17', '智联招聘', '咨询师', '尹林燕', '20', '15998507101', '女');
INSERT INTO `job` VALUES ('75', '2010-06-18', '智联招聘', '咨询师', '许颖', '27', '13604254080', '女');
INSERT INTO `job` VALUES ('76', '2010-06-18', '智联招聘', '咨询师', '李琳琳', '28', '15164011259', '女');
INSERT INTO `job` VALUES ('77', '2010-06-18', '大连快线', '市场专员', '曲威', '29', '13941161140', '男');
INSERT INTO `job` VALUES ('78', '2010-06-18', '大连快线', '咨询师', '杨志嘉', '34', '15842682887', '女');
INSERT INTO `job` VALUES ('79', '2010-06-18', '智联招聘', '咨询师', '杜辉', '18', '1513412214', '女');
INSERT INTO `job` VALUES ('80', '2010-06-18', '智联招聘', '市场专员', '祁春磊', '19', '15524884240', '男');
INSERT INTO `job` VALUES ('81', '2010-06-18', '51job', '市场专员', '孙飞', '24', '13591395350', '男');
INSERT INTO `job` VALUES ('82', '2010-06-18', '51job', '咨询师', '臧贺诗', '21', '13604089580', '女');
INSERT INTO `job` VALUES ('83', '2010-06-18', '51job', '咨询师', '郭莹莹', '22', '13889582987', '女');
INSERT INTO `job` VALUES ('84', '2010-06-20', '51job', '咨询师', '孙晓旭', '23', '15909856550', '女');
INSERT INTO `job` VALUES ('85', '2010-06-20', '51job', '咨询师', '李雪瑾', '20', '13591765866', '女');
INSERT INTO `job` VALUES ('86', '2010-06-20', '智联招聘', '咨询顾问', '何英', '25', '15542598526', '女');
INSERT INTO `job` VALUES ('87', '2010-06-20', '智联招聘', '咨询顾问', '周萍', '20', '13130000766', '女');
INSERT INTO `job` VALUES ('88', '2010-06-21', '智联招聘', '市场专员', '尹晓晨', '27', '15940279985', '男');
INSERT INTO `job` VALUES ('89', '2010-06-21', '智联招聘', '市场专员', '吉慧', '28', '15101188923', '女');
INSERT INTO `job` VALUES ('90', '2010-06-21', '大连快线', '网络推广', '郭聪聪', '29', '13624916357', '女');
INSERT INTO `job` VALUES ('91', '2010-06-21', '51job', '美工', '孙尚敏', '34', '13795119835', '女');
INSERT INTO `job` VALUES ('92', '2010-06-22', '大连快线', '咨询师', '陈雪', '18', '13795113767', '女');
INSERT INTO `job` VALUES ('93', '2010-06-22', '智联招聘', '市场专员', '傅强', '19', '13842843462', '男');
INSERT INTO `job` VALUES ('94', '2010-06-22', '大连快线', '网络推广', '曲莹', '24', '15134170302', '女');
INSERT INTO `job` VALUES ('95', '2010-06-22', '51job', '市场专员', '韩健亮', '21', '15040527382', '男');
INSERT INTO `job` VALUES ('96', '2010-06-25', '智联招聘', '咨询师', '陈哲睿', '22', '15940989284', '女');
INSERT INTO `job` VALUES ('97', '2010-06-25', '智联招聘', '咨询师', '李宁', '23', '13478946513', '女');
INSERT INTO `job` VALUES ('98', '2010-06-25', '智联招聘', '咨询师', '朱玉', '20', '15940836504', '女');
INSERT INTO `job` VALUES ('99', '2010-06-25', '智联招聘', '咨询师', '李娜', '25', '15940823914', '女');
INSERT INTO `job` VALUES ('100', '2010-06-25', '智联招聘', '咨询师', '李秋苹', '20', '15840858794', '女');
INSERT INTO `job` VALUES ('101', '2010-06-25', '51job', '咨询师', '马丹', '27', '15904266945', '女');
INSERT INTO `job` VALUES ('102', '2010-06-25', '51job', '市场专员', '李佳璐', '28', '13260425357', '女');
INSERT INTO `job` VALUES ('103', '2010-06-25', '智联招聘', '咨询师', '王晓彤', '29', '13591755042', '女');
INSERT INTO `job` VALUES ('104', '2010-06-25', '大连快线', '网络推广', '董京众', '34', '15041140853', '女');
INSERT INTO `job` VALUES ('105', '2010-06-26', '大连快线', '网络推广', '吴桐', '18', '13943403947/13944590838', '女');
INSERT INTO `job` VALUES ('106', '2010-06-26', '51job', '咨询师', '刘东芳', '19', '15040553908', '女');
INSERT INTO `job` VALUES ('107', '2010-06-26', '51job', '咨询师', '孙景', '24', '13654206862', '女');
INSERT INTO `job` VALUES ('108', '2010-06-26', '智联招聘', '咨询师', '朱玉', '21', '15940836504', '女');
INSERT INTO `job` VALUES ('109', '2010-06-26', '智联招聘', '网络推广', '王欢', '22', '15040501060', '男');
INSERT INTO `job` VALUES ('110', '2010-06-28', '智联招聘', '咨询顾问', '张怡恒', '23', '13604267300', '女');
INSERT INTO `job` VALUES ('111', '2010-06-28', '51job', '咨询顾问', '安阳', '20', '15904560461', '女');
INSERT INTO `job` VALUES ('112', '2010-06-28', '51job', '咨询顾问', '孙晓旭', '25', '15909856550', '女');
INSERT INTO `job` VALUES ('113', '2010-06-28', '51job', '市场专员', '李晓文', '20', '15942609132', '男');
INSERT INTO `job` VALUES ('114', '2010-06-29', '智联招聘', '市场专员', '齐广宇', '27', '18941353326', '男');
INSERT INTO `job` VALUES ('115', '2010-06-29', '智联招聘', '市场专员', '尚裕', '28', '13604941676', '男');
INSERT INTO `job` VALUES ('116', '2010-06-29', '智联招聘', '市场专员', '程晟', '29', '15242646896', '男');
INSERT INTO `job` VALUES ('117', '2010-06-29', '智联招聘', '市场专员', '张书海', '34', '13555922466', '男');
INSERT INTO `job` VALUES ('118', '2010-06-29', '智联招聘', '市场专员', '姜耘彤', '18', '13478581869', '男');
INSERT INTO `job` VALUES ('119', '2010-06-29', '智联招聘', '咨询顾问', '吴盈雪', '19', '15040552226', '女');
INSERT INTO `job` VALUES ('120', '2010-06-29', '智联招聘', '咨询顾问', '王小旭', '24', '13190140637', '女');
INSERT INTO `job` VALUES ('121', '2010-06-29', '智联招聘', '咨询顾问', '刘丹', '21', '13654915296', '女');
INSERT INTO `job` VALUES ('122', '2010-06-29', '51job', '市场专员', '黄辉', '22', '13761770844', '男');
INSERT INTO `job` VALUES ('123', '2010-06-29', '51job', '市场专员', '李佳璐', '23', '13260425357', '女');
INSERT INTO `job` VALUES ('124', '2010-06-29', '大连快线', '咨询顾问', '刘东旭', '20', '18940904539', '女');
INSERT INTO `job` VALUES ('125', '2010-06-29', '智联招聘', '网络推广', '傅延隽', '25', '15042598156', '男');
INSERT INTO `job` VALUES ('126', '2010-06-29', '前程无忧', 'IT实习生', '谷春阳', '20', '15140692378', '女');
INSERT INTO `job` VALUES ('127', '2010-06-30', '大连人才', '网络推广', '高辉', '27', '15941617949', '男');
INSERT INTO `job` VALUES ('128', '2010-06-30', '大连快线', '咨询师', '廉芳', '28', '15004263202', '女');
INSERT INTO `job` VALUES ('129', '2010-06-30', '51job', '市场专员', '孙世岩', '29', '15998528212', '男');
INSERT INTO `job` VALUES ('130', '2010-06-30', '智联招聘', '市场专员', '孙玉', '34', '13840889569', '男');
INSERT INTO `job` VALUES ('131', '2010-06-30', '智联招聘', '市场专员', '宁盛君', '18', '15242589895', '男');
INSERT INTO `job` VALUES ('132', '2010-07-01', '智联招聘', '咨询师', '程程', '19', '15040252058', '女');
INSERT INTO `job` VALUES ('133', '2010-07-01', '大连快线', '咨询师', '王爽', '24', '15840986071/13904080393 ', '女');
INSERT INTO `job` VALUES ('134', '2010-07-01', '智联招聘', '美工', '李朋来', '21', '13644960850', '男');
INSERT INTO `job` VALUES ('135', '2010-07-01', '51job', '美工', '李维国', '22', '15542549234 / 0411-86694309', '男');
INSERT INTO `job` VALUES ('136', '2010-07-03', '大连人才', '咨询师', '刘娜', '23', '15942850922', '女');
INSERT INTO `job` VALUES ('137', '2010-07-03', '51job', '市场专员', '周顺东', '20', '13842612496', '男');
INSERT INTO `job` VALUES ('138', '2010-07-04', '未知', '市场专员', '高超', '25', '13654296593', '男');
INSERT INTO `job` VALUES ('139', '2010-07-04', '智联招聘', '市场专员', '薛含英', '20', '13795047715', '女');
INSERT INTO `job` VALUES ('140', '2010-07-04', '智联招聘', '市场专员', '李春宇', '27', '13555923767', '女');
INSERT INTO `job` VALUES ('141', '2010-07-04', '智联招聘', '咨询师', '董紫阳', '28', '13274602920', '女');
INSERT INTO `job` VALUES ('142', '2010-07-04', '智联招聘', '市场专员', '李伟婷', '29', '15909850211', '女');
INSERT INTO `job` VALUES ('143', '2010-07-04', '智联招聘', '市场专员', '喻雅思', '34', '15998576400', '女');
INSERT INTO `job` VALUES ('144', '2010-07-04', '大连人才', '咨询师', '赵津乐', '18', '13842603166', '女');
INSERT INTO `job` VALUES ('145', '2010-07-05', '智联招聘', '网站美工', '宁瑞先', '19', '13478598396', '女');
INSERT INTO `job` VALUES ('146', '2010-07-05', '大连人才', '市场专员', '常欣欣', '24', '15842665122', '女');
INSERT INTO `job` VALUES ('147', '2010-07-06', '51job', '市场专员', '张倩', '21', '13555970459', '女');
INSERT INTO `job` VALUES ('148', '2010-07-06', '大连快线', '网络推广', '彭女士 ', '22', '13009405890', '女');
INSERT INTO `job` VALUES ('149', '2010-07-06', '智联招聘', '市场专员', '任鸣世', '23', '13644932798', '男');
INSERT INTO `job` VALUES ('150', '2010-07-06', '智联招聘', '美工', '王晓光', '20', '13942672997', '男');
INSERT INTO `job` VALUES ('151', '2010-07-06', '智联招聘', '市场专员', '王瀚琳', '25', '13842807151', '男');
INSERT INTO `job` VALUES ('152', '2010-07-07', '智联招聘', '咨询顾问', '宋雪茹', '20', '15940912313', '女');
INSERT INTO `job` VALUES ('153', '2010-07-07', '未知', '网站美工', '姜兆莉', '27', '13555967136', '女');
INSERT INTO `job` VALUES ('154', '2010-07-07', '大连快线', '咨询顾问', '郭鸿雁', '28', '15524321131', '女');
INSERT INTO `job` VALUES ('155', '2010-07-07', '智联招聘', '市场专员', '于欢欢', '29', '13478545582', '女');
INSERT INTO `job` VALUES ('156', '2010-07-07', '智联招聘', '市场专员', '寇海川', '34', '15242525978', '男');
INSERT INTO `job` VALUES ('157', '2010-07-07', '51job', '咨询顾问', '林森', '18', '13478458795', '男');
INSERT INTO `job` VALUES ('158', '2010-07-07', '智联招聘', '咨询顾问', '唐晓芸', '19', '15865622191', '女');
INSERT INTO `job` VALUES ('159', '2010-07-08', '大连人才', '市场专员', '王一', '24', '13684665293', '男');
INSERT INTO `job` VALUES ('160', '2010-07-08', '大连快线', '咨询顾问', '孙丹', '21', '13624916491', '女');
INSERT INTO `job` VALUES ('161', '2010-07-08', '智联招聘', '美工', '孙明阳', '22', '15242677307', '男');
INSERT INTO `job` VALUES ('162', '2010-07-08', '智联招聘', '咨询师', '郭帅', '23', '15164002965', '女');
INSERT INTO `job` VALUES ('163', '2010-07-10', '智联招聘', '咨询师', '杨婷', '20', '15642701231', '女');
INSERT INTO `job` VALUES ('164', '2010-07-10', '大连快线', '咨询师', '王超', '25', '15940907259', '女');
INSERT INTO `job` VALUES ('165', '2010-07-10', '智联招聘', '网络推广', '段燕', '20', '15542396653', '男');
INSERT INTO `job` VALUES ('166', '2010-07-10', '智联招聘', '网络推广', '王凤伟', '27', '15241484165', '女');
INSERT INTO `job` VALUES ('167', '2010-07-10', '大连人才', '市场专员', '申忠飞', '28', '15940862949', '男');
INSERT INTO `job` VALUES ('168', '2010-07-10', '智联招聘', '网络推广', '许婧', '29', '15242543303', '女');
INSERT INTO `job` VALUES ('169', '2010-07-10', '智联招聘', '市场专员', '滕文强', '34', '15942448024', '男');
INSERT INTO `job` VALUES ('170', '2010-07-10', '智联招聘', '市场专员', '刘永状', '18', '15140091023', '男');
INSERT INTO `job` VALUES ('171', '2010-07-10', '智联招聘', '网络推广', '王修能', '19', '13079843743', '男');
INSERT INTO `job` VALUES ('172', '2010-07-10', '51job', '咨询师', '王志杰', '24', '15804029121', '男');
INSERT INTO `job` VALUES ('173', '2010-07-10', '51job', '咨询师', '刘芳兵', '21', '15142379065', '女');
INSERT INTO `job` VALUES ('174', '2010-07-12', '智联招聘', '市场专员', '叶鹏', '22', '13940916961', '男');
INSERT INTO `job` VALUES ('175', '2010-07-12', '智联招聘', '市场专员', '张宝鑫', '23', '15940831941', '男');
INSERT INTO `job` VALUES ('176', '2010-07-12', '智联招聘', '咨询师', '马一平', '20', '15998430283', '女');
INSERT INTO `job` VALUES ('177', '2010-07-12', '智联招聘', '网络推广', '张兆琦', '25', '13804244428', '男');
INSERT INTO `job` VALUES ('178', '2010-07-12', '智联招聘', '网络推广', '柳玉影', '20', '15998459156', '女');
INSERT INTO `job` VALUES ('179', '2010-07-12', '智联招聘', '咨询师', '窦月', '27', '15841131206', '女');
INSERT INTO `job` VALUES ('180', '2010-07-13', '智联招聘', '网络推广员', '马玉梅', '28', '15904119172', '女');
INSERT INTO `job` VALUES ('181', '2010-07-13', '智联招聘', '网络推广员', '李小转', '29', '15942864664', '女');
INSERT INTO `job` VALUES ('182', '2010-07-13', '智联招聘', '网络推广员', '孙明阳', '34', '15242677307', '男');
INSERT INTO `job` VALUES ('183', '2010-07-13', '智联招聘', '市场专员', '唐洋', '18', '15141161427', '男');
INSERT INTO `job` VALUES ('184', '2010-07-13', '智联招聘', '网络推广', '刘晋达', '19', '15604114121', '男');
INSERT INTO `job` VALUES ('185', '2010-07-13', '大连快线', '市场专员', '吴人杰', '24', '13190127061', '男');
INSERT INTO `job` VALUES ('186', '2010-07-13', '智联招聘', '网络推广员', '董立群', '21', '13998624434/13130257080', '女');
INSERT INTO `job` VALUES ('187', '2010-07-13', '智联招聘', '网络推广员', '高日超', '22', '13634981392', '男');
INSERT INTO `job` VALUES ('188', '2010-07-13', '51job', '咨询师', '刘影', '23', '15840628305', '女');
INSERT INTO `job` VALUES ('189', '2010-07-13', '智联招聘', '市场专员', '杨帆', '20', '15940952622', '女');
INSERT INTO `job` VALUES ('190', '2010-07-13', '大连快线', '市场专员', '常海静', '25', '13674247535', '女');
INSERT INTO `job` VALUES ('191', '2010-07-14', '智联招聘', '市场专员', '王广平', '20', '15040622791', '男');
INSERT INTO `job` VALUES ('192', '2010-07-14', '智联招聘', '咨询师', '陈佳佳', '27', '13591798028', '女');
INSERT INTO `job` VALUES ('193', '2010-07-14', '智联招聘', '市场专员', '夏成玲', '28', '13842450208/13893347203', '女');
INSERT INTO `job` VALUES ('194', '2010-07-15', '智联招聘', '市场专员', '卢时强', '29', '13609863754', '男');
INSERT INTO `job` VALUES ('195', '2010-07-15', '大连人才', '市场专员', '赵萃', '34', '15134152139', '女');
INSERT INTO `job` VALUES ('196', '2010-07-15', '大连人才', '市场专员', '彭秋燕', '18', '13009405890/0411-83629044', '女');
INSERT INTO `job` VALUES ('197', '2010-07-16', '大连人才', '行政', '曲文君', '19', '15840680822', '女');
INSERT INTO `job` VALUES ('198', '2010-07-16', '智联招聘', 'PHP程序员', '李晓轲', '24', '13842857005', '男');
INSERT INTO `job` VALUES ('199', '2010-07-16', '智联招聘', '行政', '刘丹丹', '21', '13478579553', '女');
INSERT INTO `job` VALUES ('200', '2010-07-16', '智联招聘', '行政', '赵静', '22', '15698850901', '女');
INSERT INTO `job` VALUES ('201', '2010-07-17', '大连人才', '市场专员', '丁健', '23', '15840969684', '男');
INSERT INTO `job` VALUES ('202', '2010-07-17', '智联招聘', '行政', '祝文月', '20', '13700419973', '女');
INSERT INTO `job` VALUES ('203', '2010-07-17', '智联招聘', '行政', '冀禹希', '25', '15040648285', '女');
INSERT INTO `job` VALUES ('204', '2010-07-17', '智联招聘', '行政', '闵祥凤', '20', '15998472381', '女');
INSERT INTO `job` VALUES ('205', '2010-07-17', '智联招聘', '市场专员', '王宁', '27', '13591119066', '男');
INSERT INTO `job` VALUES ('206', '2010-07-17', '智联招聘', '市场专员', '徐小婷', '28', '13898448925', '女');
INSERT INTO `job` VALUES ('207', '2010-07-19', '智联招聘', '市场专员', '高传龙', '29', '15941901607', '男');
INSERT INTO `job` VALUES ('208', '2010-07-19', '智联招聘', '行政', '王雪峰', '18', '13840905850', '女');
INSERT INTO `job` VALUES ('209', '2010-07-19', '智联招聘', '市场专员', '张新', '19', '18940872480', '女');
INSERT INTO `job` VALUES ('210', '2010-07-19', '智联招聘', '市场专员', '贾旭东', '24', '15840918789', '男');
INSERT INTO `job` VALUES ('211', '2010-07-19', '智联招聘', '市场专员', '姜阳', '21', '13500767037', '女');
INSERT INTO `job` VALUES ('212', '2010-07-20', '智联招聘', '咨询师', '赵丹', '22', '15840901656', '女');
INSERT INTO `job` VALUES ('213', '2010-07-20', '大连人才', '行政', '李营', '23', '13500708974', '女');
INSERT INTO `job` VALUES ('214', '2010-07-20', '智联招聘', '咨询顾问', '刘丹', '20', '13889536123', '女');
INSERT INTO `job` VALUES ('215', '2010-07-20', '智联招聘', '市场专员', '唐芳芳', '25', '158-4065-7179', '女');
INSERT INTO `job` VALUES ('216', '2010-07-20', '智联招聘', '行政', '杨楠', '20', '15904954620', '女');
INSERT INTO `job` VALUES ('217', '2010-07-20', '智联招聘', '咨询顾问', '鲍文瑾', '27', '15841106340| 15242553910', '女');
INSERT INTO `job` VALUES ('218', '2010-07-20', '智联招聘', '行政', '李萌', '28', '15142336694', '女');
INSERT INTO `job` VALUES ('219', '2010-07-20', '智联招聘', '行政', '崔贝妮', '29', '13478402783', '女');
INSERT INTO `job` VALUES ('220', '2010-07-21', '智联招聘', '行政', '李爽', '34', '13478414156', '女');
INSERT INTO `job` VALUES ('221', '2010-07-21', '智联招聘', '行政', '张楠', '18', '13644084611', '女');
INSERT INTO `job` VALUES ('222', '2010-07-21', '智联招聘', '行政', '李岩', '19', '13555974200', '女');
INSERT INTO `job` VALUES ('223', '2010-07-21', '大连人才', '行政', '李营', '24', '13500708974', '女');
INSERT INTO `job` VALUES ('224', '2010-07-22', '智联招聘', '行政', '王冬艳', '21', '15940986502', '女');
INSERT INTO `job` VALUES ('225', '2010-07-25', '大连快线', '市场专员', '王佳美', '22', '15040538190', '女');
INSERT INTO `job` VALUES ('226', '2010-07-25', '大连快线', '市场专员', '杨大利', '23', '13624988165', '男');
INSERT INTO `job` VALUES ('227', '2010-07-25', '智联招聘', '市场专员', '韩  倩', '20', '13842827558', '女');
INSERT INTO `job` VALUES ('228', '2010-07-25', '智联招聘', '行政', '房艳艳', '25', '13591835437', '女');
INSERT INTO `job` VALUES ('229', '2010-07-25', '智联招聘', '行政', '李虹', '20', '15840839361', '女');
INSERT INTO `job` VALUES ('230', '2010-07-25', '智联招聘', '行政', '刘奕宁', '27', '13504268499', '女');
INSERT INTO `job` VALUES ('231', '2010-07-25', '智联招聘', '行政', '孙睿彤', '28', '15142410679', '女');
INSERT INTO `job` VALUES ('232', '2010-07-25', '智联招聘', '行政', '刘旭', '29', '13998451003', '女');
INSERT INTO `job` VALUES ('233', '2010-07-25', '智联招聘', '市场专员', '都红', '34', '15041162158', '女');
INSERT INTO `job` VALUES ('234', '2010-07-27', '智联招聘', '市场专员', '林雪松', '18', '14741125186', '男');
INSERT INTO `job` VALUES ('235', '2010-07-27', '大连快线', '网络推广', '伦玉红', '19', '13889583527', '女');
INSERT INTO `job` VALUES ('236', '2010-07-27', '大连人才', '网络推广', '安巧玲', '24', '13591744940', '女');
INSERT INTO `job` VALUES ('237', '2010-07-27', '智联招聘', '网络推广', '阚婷婷', '21', '15140501343/13514240625', '女');
INSERT INTO `job` VALUES ('238', '2010-07-27', '智联招聘', '网络推广', '张春晖', '22', '13842690548', '男');
INSERT INTO `job` VALUES ('239', '2010-07-27', '智联招聘', '市场专员', '张妮', '23', '15898396616', '女');
INSERT INTO `job` VALUES ('240', '2010-07-27', '智联招聘', '行政', '郭玉飞', '20', '15040608965', '男');
INSERT INTO `job` VALUES ('241', '2010-07-27', '智联招聘', '行政', '阚婷婷', '25', '13354085224', '女');
INSERT INTO `job` VALUES ('242', '2010-07-27', '智联招聘', '行政', '任玮', '20', '15941392129', '女');
INSERT INTO `job` VALUES ('243', '2010-07-28', '智联招聘', '行政', '王瑞林', '27', '15942422856', '女');
INSERT INTO `job` VALUES ('244', '2010-07-28', '智联招聘', '行政', '费超', '28', '13898611068', '女');
INSERT INTO `job` VALUES ('245', '2010-07-28', '智联招聘', '行政', '曹玉玮', '29', '15542560981', '女');
INSERT INTO `job` VALUES ('246', '2010-07-28', '智联招聘', '行政', '孙奇奇', '34', '15940914419', '女');
INSERT INTO `job` VALUES ('247', '2010-07-28', '智联招聘', '行政', '刑莎莎', '18', '13591740376   13936560248', '女');
INSERT INTO `job` VALUES ('248', '2010-07-29', '智联招聘', '市场专员', '杨萌', '19', '13478916015', '女');
INSERT INTO `job` VALUES ('249', '2010-07-29', '大连快线', '网络推广', '郭亮', '24', '15542305140', '男');
INSERT INTO `job` VALUES ('250', '2010-07-30', '朋友介绍', '行政专员', '姜旭', '21', '13644093667', '女');
INSERT INTO `job` VALUES ('251', '2010-08-02', '智联招聘', '市场专员', '牛军磊', '22', '15840960338', '男');
INSERT INTO `job` VALUES ('252', '2010-08-02', '智联招聘', '咨询顾问', '张艳萍', '23', '15040632729', '女');
INSERT INTO `job` VALUES ('253', '2010-08-03', '智联招聘', '市场专员', '赵泉涌', '20', '15840802500', '男');
INSERT INTO `job` VALUES ('254', '2010-08-03', '智联招聘', '市场专员', '解鑫', '25', '13478701294', '男');
INSERT INTO `job` VALUES ('255', '2010-08-03', '智联招聘', '咨询顾问', '王思蒙', '20', '13610953313', '女');
INSERT INTO `job` VALUES ('256', '2010-08-03', '智联招聘', '市场专员', '魏首', '27', '13591375928', '女');
INSERT INTO `job` VALUES ('257', '2010-08-05', '智联招聘', '咨询顾问', '张小姐', '28', '13940408064', '女');
INSERT INTO `job` VALUES ('258', '2010-08-05', '智联招聘', '市场专员', '赵瑞芳', '29', '13709862087', '女');
INSERT INTO `job` VALUES ('259', '2010-08-05', '智联招聘', '咨询师', '张月华', '34', '13840861747   15104514685 ', '女');
INSERT INTO `job` VALUES ('260', '2010-08-05', '智联招聘', '市场专员', '刘德鹏', '18', '15840833892', '男');
INSERT INTO `job` VALUES ('261', '2010-08-05', '智联招聘', '市场专员', '孙飞 ', '19', '13591395350', '男');
INSERT INTO `job` VALUES ('262', '2010-08-05', '智联招聘', '市场专员', '郑雪', '24', '13478798970', '女');
INSERT INTO `job` VALUES ('263', '2010-08-05', '大连人才', '咨询师', '解静', '21', '13998558095', '女');
INSERT INTO `job` VALUES ('264', '2010-08-06', '智联招聘', '咨询顾问', '吕娜娜', '22', '13889488390', '女');
INSERT INTO `job` VALUES ('265', '2010-08-06', '智联招聘', '咨询师', '徐芳芳', '23', '15040472850', '女');
INSERT INTO `job` VALUES ('266', '2010-08-09', '智联招聘', '咨询顾问', '姜雪', '20', '15845673726', '女');
INSERT INTO `job` VALUES ('267', '2010-08-09', '智联招聘', '咨询师', '丁琳', '25', '13130001164/86515886', '女');
INSERT INTO `job` VALUES ('268', '2010-08-09', '大连人才', '咨询师', '王国杰', '20', '15042401920', '男');
INSERT INTO `job` VALUES ('269', '2010-08-09', '智联招聘', '咨询顾问', '戚阳', '27', '15940946810', '男');
INSERT INTO `job` VALUES ('270', '2010-08-10', '智联招聘', '咨询顾问', '王潇', '28', '13624988483', '女');
INSERT INTO `job` VALUES ('271', '2010-08-11', '智联招聘', '咨询师 ', '吕洋', '29', '15164090211', '女');
INSERT INTO `job` VALUES ('272', '2010-08-11', '大连快线', '咨询师 ', '刘欢', '34', '15241135319', '女');
INSERT INTO `job` VALUES ('273', '2010-08-11', '智联招聘', '咨询师 ', '孙建华', '18', '15053210162', '女');
INSERT INTO `job` VALUES ('274', '2010-08-11', '51job', '市场专员', '刘明明', '19', '13609855560', '女');
INSERT INTO `job` VALUES ('275', '2010-08-11', '智联招聘', '市场专员', '吴大全', '24', '15524877962', '男');
INSERT INTO `job` VALUES ('276', '2010-08-12', '智联招聘', '市场专员', '陈俊宏', '21', '13478453291', '男');
INSERT INTO `job` VALUES ('277', '2010-08-12', '智联招聘', '市场专员', '姜金平', '22', '13898688725', '男');
INSERT INTO `job` VALUES ('278', '2010-08-13', '大连快线', '咨询顾问', '刘乙蓉', '23', '15940999462', '女');
INSERT INTO `job` VALUES ('279', '2010-08-13', '智联招聘', '市场专员', '姜振兴', '20', '15140437452', '男');
INSERT INTO `job` VALUES ('280', '2010-08-13', '51job', '咨询师', '唐帅', '25', '13624247718', '男');
INSERT INTO `job` VALUES ('281', '2010-08-16', '智联招聘', '咨询顾问', '滕玉辉', '20', '13604020217', '女');
INSERT INTO `job` VALUES ('282', '2010-08-16', '大连人才', '咨询师', '金明辉', '27', '13591129934', '男');
INSERT INTO `job` VALUES ('283', '2010-08-16', '智联招聘', '市场专员', '高洪波', '28', '13795106244', '男');
INSERT INTO `job` VALUES ('284', '2010-08-16', '大连人才', '市场专员', '于洋', '29', '13478931214', '男');
INSERT INTO `job` VALUES ('285', '2010-08-16', '大连快线', '咨询师', '李海琳', '34', '15998632972', '女');
INSERT INTO `job` VALUES ('286', '2010-08-16', '大连快线', '咨询师', '王晓姝', '18', '13840812390', '女');
INSERT INTO `job` VALUES ('287', '2010-08-16', '智联招聘', '咨询顾问', '徐晓凤', '19', '13898417166', '女');
INSERT INTO `job` VALUES ('288', '2010-08-17', '大连快线', '咨询顾问', '杨洋', '24', '15840975180', '女');
INSERT INTO `job` VALUES ('289', '2010-08-17', '智联招聘', '咨询顾问', '张禹', '21', '13332279522', '女');
INSERT INTO `job` VALUES ('290', '2010-08-18', '大连快线', '咨询顾问', '王钰婷', '22', '18704280886', '女');
INSERT INTO `job` VALUES ('291', '2010-08-19', '智联招聘', '咨询顾问', '崔明宇', '23', '15998458941', '女');
INSERT INTO `job` VALUES ('292', '2010-08-19', '智联招聘', '咨询师', '沈美成', '20', '15164063057', '女');
INSERT INTO `job` VALUES ('293', '2010-08-20', '大连快线', '咨询顾问', '孟凡蓦', '25', '13130028193', '女');
INSERT INTO `job` VALUES ('294', '2010-08-20', '智联招聘', '咨询顾问', '李微微', '20', '41182902031', '女');
INSERT INTO `job` VALUES ('295', '2010-08-20', '智联招聘', '咨询顾问', '王翀', '27', '13942074475', '女');
INSERT INTO `job` VALUES ('296', '2010-08-20', '大连快线', '咨询顾问', '高媛', '28', '13204057160', '女');
INSERT INTO `job` VALUES ('297', '2010-08-20', '大连快线', '咨询顾问', '刘晓飞', '29', NULL, '男');
INSERT INTO `job` VALUES ('298', '2010-08-27', '51job', '咨询师', '韩丹', '34', '15941187189', '女');
INSERT INTO `job` VALUES ('299', '2010-08-27', '51job', '咨询师', '周冬梅', '18', '15140550186', '女');
INSERT INTO `job` VALUES ('300', '2010-08-27', '智联招聘', '市场专员', '闫国亮', '19', '18909855731', '男');
INSERT INTO `job` VALUES ('301', '2010-08-27', '邮箱', '咨询师', '郝佳', '24', '13478991831', '女');
INSERT INTO `job` VALUES ('302', '2010-08-27', '智联招聘', '校园招聘代理', '刘轩麟', '21', '13624285181', '男');
INSERT INTO `job` VALUES ('303', '2010-08-30', '智联招聘', '咨询顾问', '史金玲', '22', '13795135203', '女');
INSERT INTO `job` VALUES ('304', '2010-08-30', '51job', '咨询师', '王雪', '23', '15142419828', '女');
INSERT INTO `job` VALUES ('305', '2010-08-30', '51job', '市场专员', '白培明', '20', '13795172797', '男');
INSERT INTO `job` VALUES ('306', '2010-08-30', '大连在线', '咨询师', '付丛伟', '25', '13478477174', '男');
INSERT INTO `job` VALUES ('307', '2010-08-30', '智联招聘', '校园代理', '宋军', '20', '15941121236', '男');
INSERT INTO `job` VALUES ('308', '2010-08-30', '邮箱', '咨询师', '沈航如', '27', '15904040471', '男');
INSERT INTO `job` VALUES ('309', '2010-08-30', '邮箱', '咨询师', '王桐', '28', '13130498246', '女');
INSERT INTO `job` VALUES ('310', '2010-08-30', '邮箱', '市场专员', '田野', '29', '13478630298', '男');
INSERT INTO `job` VALUES ('311', '2010-08-31', '智联招聘', '校园代理', '袁媛', '34', '13009400649', '女');
INSERT INTO `job` VALUES ('312', '2010-08-31', '大连在线', '咨询师', '孙玮', '18', '15940986160', '女');
INSERT INTO `job` VALUES ('313', '2010-08-31', '大连在线', '咨询顾问', '刘晓玉', '19', '13555927145', '女');
INSERT INTO `job` VALUES ('314', '2010-08-31', '邮箱', '市场专员', '田昊', '24', '13942810437', '男');
INSERT INTO `job` VALUES ('315', '2010-09-01', '智联招聘', '市场专员', '戚阳', '21', '15940946810', '男');
INSERT INTO `job` VALUES ('316', '2010-09-01', '大连快线', '市场专员', '李洋', '22', '18742538267', '女');
INSERT INTO `job` VALUES ('317', '2010-09-01', '大连快线', '咨询顾问', '王创', '23', '13555965458', '女');
INSERT INTO `job` VALUES ('318', '2010-09-02', '智联招聘', '校园代理', '韩迎召', '20', '15840626468', '男');
INSERT INTO `job` VALUES ('319', '2010-09-02', '智联招聘', '咨询顾问', '孙晓旭', '25', '15941321047', '男');
INSERT INTO `job` VALUES ('320', '2010-09-02', '智联招聘', '咨询顾问', '丛超逸', '20', '15945315966', '女');
INSERT INTO `job` VALUES ('321', '2010-09-02', '智联招聘', '市场专员', '贾丹', '27', '15041130304/13918369859', '女');
INSERT INTO `job` VALUES ('322', '2010-09-02', '51job', '市场专员', '李艳', '28', '13704269713', '女');
INSERT INTO `job` VALUES ('323', '2010-09-02', '51job', '校园代理', '丁锐', '29', '15004675534', '男');
INSERT INTO `job` VALUES ('324', '2010-09-02', '智联招聘', '校园代理', '王翠', '34', '13654095434', '女');
INSERT INTO `job` VALUES ('325', '2010-09-02', '邮箱', '咨询师', '孙伟婷', '18', '15140463521', '女');
INSERT INTO `job` VALUES ('326', '2010-09-03', '51job', '咨询师', '赵俊波', '19', '13842666997', '男');
INSERT INTO `job` VALUES ('327', '2010-09-03', '51job', '校园代理', '涂德明', '24', '15241151183', '男');
INSERT INTO `job` VALUES ('328', '2010-09-03', '大连在线', '咨询师', '孙嘉晨', '21', '13591119608', '女');
INSERT INTO `job` VALUES ('329', '2010-09-03', '大连在线', '咨询师', '孙玉岩', '22', '15502638222', '男');
INSERT INTO `job` VALUES ('330', '2010-09-03', '大连在线', '咨询师', '崔莹', '23', '13998556697', '女');
INSERT INTO `job` VALUES ('331', '2010-09-06', '智联招聘', '市场专员', '蔡秀丽', '20', '13050527638', '女');
INSERT INTO `job` VALUES ('332', '2010-09-06', '智联招聘', '网络推广', '孟庆庆', '25', '15941110114', '女');
INSERT INTO `job` VALUES ('333', '2010-09-06', '智联招聘', '网络推广', '于建浩', '20', '15942895075', '男');
INSERT INTO `job` VALUES ('334', '2010-09-06', '大连在线', '校园代理', '李光亮', '27', '13478420292', '男');
INSERT INTO `job` VALUES ('335', '2010-09-06', '大连在线', '咨询师', '盛小飞', '28', '15241191835', '女');
INSERT INTO `job` VALUES ('336', '2010-09-06', '51job', '咨询师', '唐帅', '29', '13624247718', '男');
INSERT INTO `job` VALUES ('337', '2010-09-06', '51job', '咨询师', '岳耀光', '34', '15940988420', '男');
INSERT INTO `job` VALUES ('338', '2010-09-06', '51job', '市场专员', '王亚琳', '18', '13504240585', '男');
INSERT INTO `job` VALUES ('339', '2010-09-06', '51job', '市场专员/网络推广', '彭澎', '19', '13889544313', '女');
INSERT INTO `job` VALUES ('340', '2010-09-06', '51job', '网络推广', '张龙', '24', '13322213770', '男');
INSERT INTO `job` VALUES ('341', '2010-09-06', '51job', '网络推广', '车峰', '21', '15842493695', '男');
INSERT INTO `job` VALUES ('342', '2010-09-06', '51job', '网络推广', '金钰', '22', '13159842097', '女');
INSERT INTO `job` VALUES ('343', '2010-09-06', '51job', '网络推广', '李艳萍', '23', '13940887734', '女');
INSERT INTO `job` VALUES ('344', '2010-09-06', '51job', '网络推广', '张硕楠', '20', '13581510591', '男');
INSERT INTO `job` VALUES ('345', '2010-09-07', '智联招聘', '网络推广', '王成林', '25', '15210289840', '男');
INSERT INTO `job` VALUES ('346', '2010-09-07', '智联招聘', '市场专员', '刘泓淼', '20', '15842458236', '男');
INSERT INTO `job` VALUES ('347', '2010-09-07', '智联招聘', '市场专员', '元东娜', '27', '13555997274', '女');
INSERT INTO `job` VALUES ('348', '2010-09-07', '51job', '网络推广', '朱冬佳', '28', '13889489744', '男');
INSERT INTO `job` VALUES ('349', '2010-09-07', '智联招聘', '网络推广', '杜楷亮', '29', '13478436072', '男');
INSERT INTO `job` VALUES ('350', '2010-09-07', '智联招聘', '校园代理', '王帅', '34', '13804261280', '男');
INSERT INTO `job` VALUES ('351', '2010-09-07', '智联招聘', '市场专员', '孙程程', '18', '13942021262', '女');
INSERT INTO `job` VALUES ('352', '2010-09-07', '大连快线', '网络推广', '黄金凤', '19', '15840648005', '女');
INSERT INTO `job` VALUES ('353', '2010-09-07', '51job', '咨询师', '米春华', '24', '13889626562', '女');
INSERT INTO `job` VALUES ('354', '2010-09-07', '52job', '网络推广', '郑雪梅', '21', '15998690107', '女');
INSERT INTO `job` VALUES ('355', '2010-09-07', '大连快线', '咨询师', '张晓芬', '22', '13545024729/15898176319', '女');
INSERT INTO `job` VALUES ('356', '2010-09-08', '智联招聘', '校园代理', '武雪莹', '23', '15142412077', '女');
INSERT INTO `job` VALUES ('357', '2010-09-08', '智联招聘', '校园代理', '孙超', '20', '15942601251', '男');
INSERT INTO `job` VALUES ('358', '2010-09-08', '智联招聘', '咨询顾问', '冯婧', '25', '13898450520', '女');
INSERT INTO `job` VALUES ('359', '2010-09-08', '51job', '网络推广', '高蕾', '20', '13478671631', '男');
INSERT INTO `job` VALUES ('360', '2010-09-08', '智联招聘', '校园代理', '马晶晶', '27', '13644097146', '女');
INSERT INTO `job` VALUES ('361', '2010-09-08', '邮箱', '咨询师', '晓倩', '28', '13940850727', '女');
INSERT INTO `job` VALUES ('362', '2010-09-09', '智联招聘', '咨询顾问', '张岩', '29', '15840628816', '女');
INSERT INTO `job` VALUES ('363', '2010-09-09', '大连在线', '市场专员', '燕云', '34', '13609851120', '男');
INSERT INTO `job` VALUES ('364', '2010-09-09', '邮箱', '网络推广', '韩晓', '18', '13942835394', '男');
INSERT INTO `job` VALUES ('365', '2010-09-09', '邮箱', '咨询师', '孙晓娜', '19', '13840977237', '女');
INSERT INTO `job` VALUES ('366', '2010-09-10', '智联招聘', '咨询顾问', '张姣姣', '24', '15842691214', '女');
INSERT INTO `job` VALUES ('367', '2010-09-10', '大连在线', '咨询师', '邓美琴', '21', '15842686109', '女');
INSERT INTO `job` VALUES ('368', '2010-09-10', '大连快线', '网络推广', '崔雪', '22', '15904251443', '女');
INSERT INTO `job` VALUES ('369', '2010-09-11', '智联招聘', '咨询顾问', '杨文欢', '23', '15945505258', '女');
INSERT INTO `job` VALUES ('370', '2010-09-11', '51job', '校园代理', '姜琰', '20', '18940914130', '女');
INSERT INTO `job` VALUES ('371', '2010-09-11', '52job', '网络推广', '任鹏飞', '25', '13110399331', '男');
INSERT INTO `job` VALUES ('372', '2010-09-11', '邮箱', '咨询师', '陈艳艳', '20', '15998412995', '女');
INSERT INTO `job` VALUES ('373', '2010-09-11', '邮箱', '咨询师', '乔璐', '27', '18741121703', '女');
INSERT INTO `job` VALUES ('374', '2010-09-11', '大连在线', '市场专员', '崔丽苹', '28', '15092402322', '女');
INSERT INTO `job` VALUES ('375', '2010-09-13', '智联招聘', '网络推广', '高薪蕙', '29', '15898119950', '女');
INSERT INTO `job` VALUES ('376', '2010-09-13', '智联招聘', '校园代理', '张森', '34', '15998596167', '男');
INSERT INTO `job` VALUES ('377', '2010-09-13', '51job', '咨询师', '蔡明', '18', '15042445425', '男');
INSERT INTO `job` VALUES ('378', '2010-09-13', '大连在线', '咨询师', '李冬', '19', '13555987813', '女');
INSERT INTO `job` VALUES ('379', '2010-09-13', '大连在线', '市场专员', '姜秋菊', '24', '13998460375', '女');
INSERT INTO `job` VALUES ('380', '2010-09-14', '智联招聘', '咨询顾问', '谷雨', '21', '15040551465', '女');
INSERT INTO `job` VALUES ('381', '2010-09-14', '51job', '市场专员', '刘颖', '22', '13591153760', '女');
INSERT INTO `job` VALUES ('382', '2010-09-14', '大连在线', '咨询师', '徐凤玲', '23', '13352266821', '女');
INSERT INTO `job` VALUES ('383', '2010-09-14', '大连快线', '网络推广', '刘红梅', '20', '15842637903', '女');
INSERT INTO `job` VALUES ('384', '2010-09-14', '邮箱', '市场专员', '彭健楠', '25', '15941320897', '男');
INSERT INTO `job` VALUES ('385', '2010-09-15', '智联招聘', '咨询顾问', '马宁', '20', '13942823469', '女');
INSERT INTO `job` VALUES ('386', '2010-09-15', '邮箱', '咨询师', '张晓芬', '27', '15898176319', '女');
INSERT INTO `job` VALUES ('387', '2010-09-15', '邮箱', '咨询师', '王丹丹', '28', NULL, '女');
INSERT INTO `job` VALUES ('388', '2010-09-16', '智联招聘', '咨询顾问', '徐曼', '29', '15140370176', '女');
INSERT INTO `job` VALUES ('389', '2010-09-16', '智联招聘', '咨询顾问', '刘树芳', '34', '15898168943', '女');
INSERT INTO `job` VALUES ('390', '2010-09-16', '智联招聘', '咨询顾问', '王芳', '18', '15042417085', '女');
INSERT INTO `job` VALUES ('391', '2010-09-16', '智联招聘', '咨询顾问', '王娜', '19', '15840694620', '女');
INSERT INTO `job` VALUES ('392', '2010-09-16', '智联招聘', '咨询顾问', '潘欣', '24', '13591828909', '女');
INSERT INTO `job` VALUES ('393', '2010-09-16', '智联招聘', '市场专员', '孙文涛', '21', '13500707002', '男');
INSERT INTO `job` VALUES ('394', '2010-09-17', '智联招聘', '咨询顾问', '衣丽娜', '22', '15040492196', '女');
INSERT INTO `job` VALUES ('395', '2010-09-17', '智联招聘', '咨询顾问', '刘丽丽', '23', '13591391511', '女');
INSERT INTO `job` VALUES ('396', '2010-09-17', '智联招聘', '咨询顾问', '隋欣', '20', '13478666704', '女');
INSERT INTO `job` VALUES ('397', '2010-09-17', '智联招聘', '咨询顾问', '彭蕾', '25', '13387890715', '女');
INSERT INTO `job` VALUES ('398', '2010-09-17', '智联招聘', '咨询顾问', '余晓萍', '20', '15998570228', '女');
INSERT INTO `job` VALUES ('399', '2010-09-17', '智联招聘', '咨询顾问', '尚尔婷', '27', '13942691864', '女');
INSERT INTO `job` VALUES ('400', '2010-09-17', '智联招聘', '咨询顾问', '孙红军', '28', '13840820501', '女');
INSERT INTO `job` VALUES ('401', '2010-09-17', '智联招聘', '市场专员', '翟重阳', '29', '15141141683', '男');
INSERT INTO `job` VALUES ('402', '2010-09-17', '智联招聘', '市场专员', '邹峻峰', '34', '13478904593', '男');
INSERT INTO `job` VALUES ('403', '2010-09-17', '智联招聘', '市场专员', '冯国帅', '18', '13504111657', '男');
INSERT INTO `job` VALUES ('404', '2010-09-17', '智联招聘', '市场专员', '樊世广', '19', '15904942982', '男');
INSERT INTO `job` VALUES ('405', '2010-09-17', '智联招聘', '市场专员', '李楠', '24', '13654265674', '男');
INSERT INTO `job` VALUES ('406', '2010-09-17', '智联招聘', '市场专员', '马懿', '21', '15004249722', '男');
INSERT INTO `job` VALUES ('407', '2010-09-17', '智联招聘', '市场专员', '满磊', '22', '15846122164', '男');
INSERT INTO `job` VALUES ('408', '2010-09-17', '智联招聘', '市场专员', '吴帅', '23', '13889588893', '男');
INSERT INTO `job` VALUES ('409', '2010-09-17', '智联招聘', '市场专员', '张磊', '20', '15841179239', '男');
INSERT INTO `job` VALUES ('410', '2010-09-17', '智联招聘', '市场专员', '于海锋', '25', '13898630712', '男');

SET FOREIGN_KEY_CHECKS = 1;

二、employees表、department表

-- 1．查询出来自大连所有员工的信息，显示出员工的姓名，所在部门，工资总和
SELECT *,(employees.emp_wage+employees.emp_salary) AS 工资总和 FROM employees WHERE employees.emp_city = '大连'

-- 2．查询人事部门的所有员工信息，显示员工姓名，城市，基本工资和奖金（只允许使用嵌套查询）
SELECT * FROM employees WHERE employees.com_id = (SELECT department.com_id FROM department WHERE department.com_name = '人事部')

-- 3．查询employees表中工资低于所有员工平均工资的员工信息，显示员工姓名，工资字段
SELECT * FROM employees WHERE (employees.emp_wage + employees.emp_salary) < (SELECT AVG(employees.emp_wage + employees.emp_salary) FROM employees)

-- 4．查询employees表中比“冰红茶”入职晚的所有员工的信息，显示员工姓名，入职日期字段
SELECT * FROM employees WHERE employees.emp_date < (SELECT employees.emp_date from employees WHERE employees.emp_name = '冰红茶')

-- 5．查询employees表中获得最高奖金(emp_salary)的员工信息，显示员工姓名，奖金字段。
SELECT * 
FROM employees
WHERE employees.emp_salary = (SELECT MAX(employees.emp_salary) FROM employees)

-- 6．查询部门经理是“王九”的部门中所有员工信息，显示员工姓名，部门编号
SELECT * FROM employees WHERE employees.com_id = (SELECT department.com_id FROM department  WHERE department.com_manager = '王九')

-- 7．查询和张三处在同一部门的所有员工的姓名。
SELECT * FROM employees WHERE employees.com_id = (SELECT department.com_id FROM department WHERE department.com_manager = '张三')

-- 8．查询哪个部门的员工工资总额最高，显示该部门的名称及经理。
SELECT * FROM department WHERE department.com_id = 
(SELECT employees.com_id FROM employees GROUP BY employees.com_id
ORDER BY SUM(employees.emp_wage + employees.emp_salary) DESC LIMIT 1)

-- 9．查询工资最高的员工来自哪个部门，显示员工的姓名，所在部门的名称，经理名字及工资数额
SELECT department.com_name AS 部门名称,employees.emp_name AS 姓名,department.com_manager as 经理,department.com_total AS 工资总额
FROM department
LEFT JOIN employees ON department.com_id = employees.com_id
ORDER BY (employees.emp_wage + employees.emp_salary) DESC LIMIT 1

-- 10．按照部门人数由高到低显示出每个部门的名称、人数、部门负责人
SELECT department.com_name AS 部门名称,department.com_manager AS 部门经理,COUNT(employees.com_id) AS 人数
from department
LEFT JOIN employees ON employees.com_id = department.com_id
GROUP BY employees.com_id ORDER BY COUNT(employees.com_id) DESC

-- 11．显示出总销售额（com_total）最高的部门有哪些员工
SELECT * FROM employees
WHERE employees.com_id = (SELECT department.com_id FROM department WHERE department.com_total = (SELECT MAX(department.com_total) FROM department))

-- 12．查询哪个城市的员工最多，列出该城市的所有员工信息
SELECT * FROM employees WHERE employees.emp_city = 
(SELECT employees.emp_city FROM employees GROUP BY employees.emp_city ORDER BY COUNT(*) DESC LIMIT 1)

-- 13．查询哪个部门的平均年龄最大，显示出该部门的名字(比较难)
SELECT department.com_name FROM department WHERE department.com_id = 
(SELECT employees.com_id  FROM employees GROUP BY employees.com_id ORDER BY AVG(timestampdiff(year,employees.emp_date,now())) DESC LIMIT 1)

两张表的sql文：

/*
 Navicat Premium Data Transfer

 Source Server         : my_project
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : order

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 01/05/2022 11:11:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for employees
-- ----------------------------
DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees`  (
  `emp_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `emp_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `emp_cardid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `emp_wage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `emp_salary` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `emp_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `com_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `emp_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of employees
-- ----------------------------
INSERT INTO `employees` VALUES ('001', '王三', 'DJ001', '5309', '432', '大连', 'c01', '1999-01-01');
INSERT INTO `employees` VALUES ('002', '姚明', 'DJ002', '3253', '465', '大连', 'c03', '1995-05-03');
INSERT INTO `employees` VALUES ('003', '王五', 'DJ003', '4363', '215', '北京', 'c01', '1999-04-02');
INSERT INTO `employees` VALUES ('004', '王丹', 'DJ004', '3899', '123', '大连', 'c02', '2004-12-04');
INSERT INTO `employees` VALUES ('005', '冯七', 'DJ005', '5309', '547', '沈阳', 'c02', '1997-10-30');
INSERT INTO `employees` VALUES ('006', '王力宏', 'DJ007', '6544', '767', '香港', 'c04', '2000-05-24');
INSERT INTO `employees` VALUES ('007', '飞鱼', 'DJ007', '2345', '188', '北京', 'c01', '2004-12-09');
INSERT INTO `employees` VALUES ('008', 'Bruce', 'DJ008', '2341', '289', '沈阳', 'c03', '2007-12-05');
INSERT INTO `employees` VALUES ('009', 'Mr_Bruce', 'DJ009', '1353', '432', '北京', 'c03', '1999-08-13');
INSERT INTO `employees` VALUES ('010', '王丽', 'DJ010', '2349', '184', '大连', 'c03', '2005-07-12');
INSERT INTO `employees` VALUES ('011', '王三峰', 'DJ011', '4253', '432', NULL, 'c02', '1999-01-01');
INSERT INTO `employees` VALUES ('012', '王国立', 'DJ012', '4253', '432', '沈阳', 'c05', '1995-06-04');
INSERT INTO `employees` VALUES ('013', '冰红茶', 'DJ013', '2934', '891', '大连', 'c01', '2002-07-31');
INSERT INTO `employees` VALUES ('014', '跑步', 'DJ014', '1821', '200', NULL, 'c02', '2004-01-09');
INSERT INTO `employees` VALUES ('015', '画地为牢', 'DJ015', '2980', '200', NULL, 'c03', '2001-08-23');
INSERT INTO `employees` VALUES ('016', '古天乐', 'DJ016', '4912', '56', '大连', 'c02', '2003-07-12');
INSERT INTO `employees` VALUES ('017', '小雨飘飘', 'DJ017', '3000', '100', NULL, 'c01', '2000-12-12');
INSERT INTO `employees` VALUES ('018', '咖啡奶茶', 'DJ018', '3188', '290', '沈阳', 'c05', '2005-06-01');
INSERT INTO `employees` VALUES ('019', '夜雨', 'DJ019', '3446', '100', NULL, 'c05', '2004-05-18');
INSERT INTO `employees` VALUES ('020', '月伴星', 'DJ020', '4444', '180', '北京', 'c05', '2005-12-01');
INSERT INTO `employees` VALUES ('021', '沙沙', 'DJ021', '5234', '234', '大连', 'c04', '2004-05-23');
INSERT INTO `employees` VALUES ('022', '闹闹', 'DJ022', '2375', '431', NULL, 'c01', '2003-09-01');
INSERT INTO `employees` VALUES ('023', '张起', 'DJ023', '2375', '100', NULL, 'c05', '2005-12-01');
INSERT INTO `employees` VALUES ('024', '张黎', 'DJ024', '2375', '100', '大连', 'c04', '2005-12-01');
INSERT INTO `employees` VALUES ('025', '王欣', 'DJ025', '3446', '100', NULL, 'c05', '2005-12-01');
INSERT INTO `employees` VALUES ('026', '王石', 'DJ026', '5234', '100', '大连', 'c03', '2005-12-01');
INSERT INTO `employees` VALUES ('027', '李凯', 'DJ027', '5234', '100', '北京', 'c05', '2005-12-01');
INSERT INTO `employees` VALUES ('028', '杨宁', 'DJ028', '3446', '100', '大连', 'c05', '2005-12-01');
INSERT INTO `employees` VALUES ('029', '曾晶煜', 'DJ029', '3000', '100', '北京', 'c02', '2005-12-01');
INSERT INTO `employees` VALUES ('030', '李洪野', 'DJ030', '3000', '100', '北京', 'c02', '2005-12-01');
INSERT INTO `employees` VALUES ('031', '吴洋', 'DJ031', '5234', '100', '大连', 'c04', '2005-12-01');
INSERT INTO `employees` VALUES ('032', '高云松', 'DJ032', '3000', '100', NULL, 'c01', '2005-12-01');
INSERT INTO `employees` VALUES ('033', '栾德智', 'DJ033', '3000', '100', '北京', 'c01', '2005-12-01');
INSERT INTO `employees` VALUES ('034', '杨应玺', 'DJ034', '3446', '100', '北京', 'c04', '2005-12-01');
INSERT INTO `employees` VALUES ('035', '岳磊', 'DJ035', '5234', '100', NULL, 'c01', '2005-12-01');
INSERT INTO `employees` VALUES ('036', '王泽宇', 'DJ036', '3000', '100', '大连', 'c02', '2005-12-01');
INSERT INTO `employees` VALUES ('037', '辛涛', 'DJ037', '5234', '100', '北京', 'c04', '2005-12-01');
INSERT INTO `employees` VALUES ('038', '卜晓克', 'DJ038', '5234', '100', '大连', 'c02', '2005-12-01');
INSERT INTO `employees` VALUES ('039', '马德超', 'DJ039', '5234', '89', '沈阳', 'c01', '2005-12-01');
INSERT INTO `employees` VALUES ('057', '王丁', 'DJ057', '2752', '223', '北京', 'c01', '1998-04-02');
INSERT INTO `employees` VALUES ('058', 'Mr_Jack', 'DJ058', '3223', '374', '北京', 'c02', '2001-05-23');
INSERT INTO `employees` VALUES ('106', 'Mriaa', 'DJ106', '1764', '963', '沈阳', 'c03', '1999-02-26');
INSERT INTO `employees` VALUES ('110', '王三丰', 'DJ010', '4346', '432', '大连', 'c04', '1999-09-24');
INSERT INTO `employees` VALUES ('124', '朱丽', 'DJ014', '2341', '130', NULL, 'c03', '2002-08-01');

SET FOREIGN_KEY_CHECKS = 1;









/*
 Navicat Premium Data Transfer

 Source Server         : my_project
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : order

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 01/05/2022 11:11:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department`  (
  `com_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `com_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `com_manager` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `com_total` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('c01', '人事部', '张三', '30000');
INSERT INTO `department` VALUES ('c02', '市场部', '冯七', '60000');
INSERT INTO `department` VALUES ('c03', '生产部', '王九', '80000');
INSERT INTO `department` VALUES ('c04', '客服部', '张三丰', '40000');
INSERT INTO `department` VALUES ('c05', '财务部', '张国立', '50000');

SET FOREIGN_KEY_CHECKS = 1;

MySQL知道出生日期如何计算年龄：
第一种

SELECT timestampdiff(year,'1999-04-30',now())

第二种

SELECT FLOOR(DATEDIFF(CURDATE(), '1999-04-30')/365.2422)