Mysql Joins

 Create table department with two columns "department_id", "department_name".

CREATE TABLE department_tbl(  
    department_id int NOT NULL AUTO_INCREMENT,  
    department_name varchar(100) NOT NULL,  
    PRIMARY KEY (department_id)  
);

INSERT INTO department_tbl (department_name) VALUES ('IT');
INSERT INTO department_tbl (department_name) VALUES ('HR');
INSERT INTO department_tbl (department_name) VALUES ('Security');
INSERT INTO department_tbl (department_name) VALUES ('Admin');
INSERT INTO department_tbl (department_name) VALUES ('Sales');