Question

Assume the following employees.sql file:

create table employees (
   id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT NOT NULL,
   first_name VARCHAR(50),
   last_name VARCHAR(50),
   email VARCHAR(50),
   age INT,
   gender VARCHAR(50),
   company VARCHAR(50)
);
insert into employees (id, first_name, last_name, email, age, gender, company) values (1, 'Nicolas', 'Skeates', 'nskeates0@zdnet.com', 50, 'Male', 'Kwinu');
insert into employees (id, first_name, last_name, email, age, gender, company) values (2, 'Valentijn', 'Digwood', 'vdigwood1@washingtonpost.com', 40, 'Male', 'Yabox');
insert into employees (id, first_name, last_name, email, age, gender, company) values (3, 'Vita', 'Arlow', 'varlow2@jugem.jp', 39, 'Female', 'Photospace');
insert into employees (id, first_name, last_name, email, age, gender, company) values (4, 'Wilie', 'Lanning', 'wlanning3@wp.com', 31, 'Female', 'Flashset');
insert into employees (id, first_name, last_name, email, age, gender, company) values (5, 'Lemuel', 'Hannah', 'lhannah4@state.gov', 26, 'Male', 'Oyoloo');
insert into employees (id, first_name, last_name, email, age, gender, company) values (6, 'Prescott', 'Elstub', 'pelstub5@abc.net.au', 43, 'Male', 'Feedmix');
insert into employees (id, first_name, last_name, email, age, gender, company) values (7, 'Andie', 'Balston', 'abalston6@soup.io', 43, 'Male', 'Zoombeat');
insert into employees (id, first_name, last_name, email, age, gender, company) values (8, 'Bayard', 'Marryatt', 'bmarryatt7@umn.edu', 42, 'Male', 'Teklist');

insert into employees (id, first_name, last_name, email, age, gender, company) values (333, 'Archibaldo', 'Vanyatin', 'avanyatin98@seattletimes.com', 58, 'Male', 'Gigazoom');
insert into employees (id, first_name, last_name, email, age, gender, company) values (334, 'Albie', 'Callis', 'acallis99@theglobeandmail.com', 26, 'Male', 'Gigazoom');

insert into employees (id, first_name, last_name, email, age, gender, company) values (317, 'Lona', 'Rivett', 'lrivett8s@pagesperso-orange.fr', 29, 'Female', 'Babblestorm');

insert into employees (id, first_name, last_name, email, age, gender, company) values (9, 'Neron', 'Barnaby', 'nbarnaby8@nationalgeographic.com', 25, 'Male', 'Voolia');
insert into employees (id, first_name, last_name, email, age, gender, company) values (10, 'Marti', 'Quinion', 'mquinion9@barnesandnoble.com', 37, 'Female', 'Gigazoom');
insert into employees (id, first_name, last_name, email, age, gender, company) values (11, 'Jackelyn', 'Scrinage', 'jscrinagea@yolasite.com', 53, 'Female', 'Thoughtbridge');
insert into employees (id, first_name, last_name, email, age, gender, company) values (12, 'Kev', 'Sterke', 'ksterkeb@washingtonpost.com', 41, 'Male', 'Gigazoom');
insert into employees (id, first_name, last_name, email, age, gender, company) values (13, 'Lamar', 'Matzeitis', 'lmatzeitisc@xrea.com', 35, 'Male', 'Dynazzy');

insert into employees (id, first_name, last_name, email, age, gender, company) values (345, 'Kaspar', 'Walby', 'kwalby9k@shinystat.com', 34, 'Male', 'Gigazoom');
insert into employees (id, first_name, last_name, email, age, gender, company) values (14, 'Winfred', 'Reside', 'wresided@webs.com', 40, 'Male', 'Wikibox');

Do the following:

1. Download the employees.sql file (data given above)
2. Use Sqlite Browser to create an SQlite3 database.
3. Write a Node.JS application that displays every Employee in JSON format.

4. Output all the employees who work at Gigazoom

5. Output every male in JSON format

6. Output every female that works at Babblestorm in JSON format

7. Output the name of everyone who is 26 years old (just text, not JSON)

State the commands to successfully accomplish the statements above for full credit/thumbs up! Thanks!