CREATE TABLE flight (flno NUMBER, origin CLOB, destination CLOB, distance NUMBER, departure_date TIME, arrival_date TIME, price NUMBER, aid NUMBER)
CREATE TABLE certificate (eid NUMBER, aid NUMBER)
CREATE TABLE aircraft (aid NUMBER, name CLOB, distance NUMBER)
CREATE TABLE employee (eid NUMBER, name CLOB, salary NUMBER)

What is the number of employees that have a salary between 100000 and 200000?
SELECT COUNT(*) FROM employee WHERE salary BETWEEN 100000 AND 200000
SELECT COUNT(*) FROM "employee" WHERE "salary" <= 200000 AND "salary" >= 100000