-- create a table
CREATE TABLE employee (
  empid INTEGER PRIMARY KEY,
  emp_name TEXT NOT NULL,
  joining_date integer,
  salary integer
);
-- insert some values
INSERT INTO employee VALUES (1, 'Ryan', '15/01/2021', '42000');
INSERT INTO employee VALUES (2, 'Joanna', '16/01/2021','50000');
INSERT INTO employee VALUES (3, 'rohit', '17/01/2021','70000');
INSERT INTO employee VALUES (4, 'gunesh', '18/01/2021','45000');
INSERT INTO employee VALUES (5, 'harish', '19/01/2021','55000');
INSERT INTO employee VALUES (6, 'Asmita', '20/01/2021','57000');
INSERT INTO employee VALUES (7, 'Annaya', '21/01/2021','56000');
INSERT INTO employee VALUES (8, 'deepak', '22/01/2021','58000');
INSERT INTO employee VALUES (9, 'Sayali', '23/01/2021','59000');
INSERT INTO employee VALUES (10, 'Sammir', '24/01/2021','60000');
-- fetch some values
select dintinct(salary ) from employee;
select * from employee order by joining date desc;
select group