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;
To embed this project on your website, copy the following code and paste it into your website's HTML: