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

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