CREATE TABLE employees (
  last_name CHAR NOT NULL,
  first_name CHAR NOT NULL,
  email VARCHAR(20),
  phone_number INT,
  job_id VARCHAR,
  salary FLOAT,
  manager_id INT,
  manager_name CHAR,
  department_id VARCHAR
);
INSERT INTO employees (last_name, first_name, email, phone_number, job_id, salary, manager_id, manager_name, department_id) VALUES
  ('Smith', 'hitesh', 'john.smith@example.com', 1234567890, 'J001', 3000, NULL, NULL, '158'),
  ('Johnson', 'Mary', 'mary.johnson@example.com', 2345678901, 'J002', 3000, 121, 'John Smith', '158'),
  ('Williams', 'David', 'david.williams@example.com', 3456789012, 'J003', 3000, 121, 'John Smith', 'D002'),
  ('Brown', 'Linda', 'linda.brown@example.com', 4567890123, 'J004', 80000, 1, 'John Smith', 'D002'),
  ('Jones', 'Robert', 'robert.jones@example.com', 5678901234, 'J005', 90000, 1, 'John Smith', 'D003');

SELECT last_name, first_name,job_id, department_id FROM employees where department_id = 158;

SELECT*FROM employees where first_name = 'hitesh';
SELECT*from employees where salary = 3000 and manager_id = 121;