CREATE TABLE employees (
  emp_id INTEGER PRIMARY KEY,
  first_name TEXT NOT NULL,
  last_name TEXT NOT NULL,
  salary INTEGER NOT NULL
);

INSERT INTO employees VALUES (434, 'pranav', 'rajput', 5000000);
INSERT INTO employees VALUES (212, 'sristy', 'singh', 3500000);
INSERT INTO employees VALUES (151, 'shradha', 'rajlok', 7800000);
INSERT INTO employees VALUES (676, 'atul', 'verma', 1200000);
INSERT INTO employees VALUES (989, 'lenz', 'amonez', 1400000);
INSERT INTO employees VALUES (797, 'daniel', 'specka', 1600000);
INSERT INTO employees VALUES (585, 'albert', 'nate', 1500000);

SELECT last_name FROM employees WHERE last_name like '%a%e%' OR last_name like '%e%a%' order by emp_id;

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: