Untitled
create DATABASE employee_list; use employee_list create table employee_list( employee_id int, first_name varchar(20), last_name varchar(20), department varchar(20), salary float, hire_date date ); INSERT INTO employee_list( employee_id,first_name,last_name,department,salary,hire_date) VALUES (1,'Jhon','Doe','Finance',75000,"2019-06-15"), (2,'Jane','Smith','IT',60000,"2021-03-22"), (3,'Alice','Jhonson','Finance',50000,"2018-11-10"), (4,'Bob','Brown','HR',45000,"2020-01-05"), (5,'Charlie','Davis','Finance',120000,"2017-09-30");
Leave a Comment