Writing queries in SQL.

Q16. Define two views of containing name, gender, street and city information for employees living in Omaha and Lincoln, respectively, and execute these views separately. (So this query has two independent parts.) Q17. Find names of male employees living in Omaha or Lincoln. You should use the two views defined above to execute this query.

Employee (Lastname, FirstName, MidInitial, gender, street, city)

Works (Lastname, FirstName, MidInitial, company-name, salary)

company (company-name, city)

Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date)