title: SQL queries for employee database
body: <p>I am new to SQL and I am taking a DB class this semester. I have about 20 queries to try on this database and there are two of them that I cannot figure out... I was wondering if someone here would be able to help!</p>
  
  <p>Here are my tables I created already.</p>
  
  <pre><code>create table employee(
    EID varchar(20) primary key,
    Lastname varchar(20),
    Firstname varchar(20),
    Midinitial char(1),
    gender char(1),
    street varchar(20),
    city varchar(20)
  );
  
  create table works(
    EID varchar(20) primary key,
    Lastname varchar(20),
    Firstname varchar(20),
    Midinitial char(1),
    company_name varchar(20),
    salary numeric(5,0),
    foreign key(EID) references employee,
    foreign key(company_name) references company
  );
  
  create table company(
    company_name varchar(20) primary key,
    city varchar(20)
  );
  
  create table manages(
    EID varchar(20) primary key,
    Lastname varchar(20),
    Firstname varchar(20),
    Midinitial char(1),
    ManagerLastname varchar(20),
    MFirstname varchar(20),
    MMidinitial varchar(20),
    start_date date,
    foreign key (EID) references employee
  );
  </code></pre>
  
  <p>Find the salaries of all managers who work for First Bank and live in Omaha.</p>
  
  <p>Here is what I have for this one I think its correct but I dont want to answer this until I can get the second one too....</p>
  
  <pre><code>select distinct salary
  from employee, works, manages
  where employee.city = 'Omaha' 
    and works.company_name = 'First Bank' 
    and manages.managerlastname = employee.Lastname
    and employee.EID = works.EID
  </code></pre>
  
  <p>and </p>
  
  <p>Find the name and the company name of the employee who has the highest salary of all employees.</p>