Untitled

 avatar
unknown
plain_text
14 days ago
600 B
3
Indexable
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