-- create a table
/*CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';*/

 -- show DATABASEs;
-- select DATABASE();
-- show tables;
-- create database pandian_Stores;

CREATE TABLE EMPLOYEES (
    emp_id int,
    emp_name varchar(50),
    emp_gender varchar(1),
    emp_email varchar(50),
    emp_salary decimal(7,2),
    Mobile_Number varchar(10),
    emp_join_date date
    );

 -- show tables;

insert into EMPLOYEES values
    (1,"Deva","M","Deva@unionleader.com",50000.50,"9025726759","2005-05-02"),
    (2,"Kaaleesha","M","kaleesha@unionleader.com",70000.50,"1234567890","1951-05-02"),
   (3,"Simon","M","Simon@unionleader.com",50000.50,"9999999999","1995-05-02"),
       (4,"Monica","F","Monica@unionleader.com",50000.50,"8888888888","2005-05-02"),
       (5,"Dayal","M","Dayal@unionleader.com",50000.50,"7777777777","2015-05-02");

-- DELETE from EMPLOYEES where emp_id=5;

select emp_id,emp_name from EMPLOYEES;