sql学习-dfgs

create table employee(emp_id int primary key,emp_sex char(40),emp_email varchar(50),emp_salary varchar(10),emp_bonu varchar(10),emp_job_id int,emp_dept_id int,emp_manager varchar(50),emp_name char(10),emp_date date);

load data local infile ‘/root/mysql/employee/employee.csv’ into table employee
fields terminated by ‘,’;

结合日历信息表，分析打卡记录表attendance中的检查日期(check_date)为工作日还是非工作日，结果存为视图table1。(字段：id check_date is_work_day)
create view table1 as select attendance.id,attendance.check_date,calendar.is_work_day from attendance inner join calendar on attendance.id=calendar.id;

create view table2 as select employee.emp_name,count(attendance.check_date) as ‘att_days’ from employee inner join attendance on employee.emp_id=attendance.emp_id group by employee.emp_name;

查询2021年1月所有迟到的人员信息（即早上打卡时间晚于09:00:00），结果存为视图table3。（字段：calendar_date、emp_name、clock_in）
create view table3 as sel