用mysql创建数据库代码（128mysql建表和简单sql）

EMPLOYEES, 有四个字段，EMPLOYEE_ID:员工表(主键)、DEPT_ID:部门号、EMPLOYEE_NAME:员工姓名、EMPLOYEE_SALARY:员工工资。

CREATE TABLE EMPLOYEES(

EMPLOYEE_ID int not null primary key,

DEPT_ID int,

EMPLOYEE_NAME char(40),

EMPLOYEE_SALARY double

);

select * from employee where employee. salary= (select max(employee_salary) from employee)

select dept_id,count(*) cno from user GROUP BY dept_id desc limit 1