Writing queries in SQL.

Q7. Find the name and the company name of the employee who has the highest salary of all employees. Q8. (a) Define a view ManagerInfo consisting of names, streets and cities of managers and (b) then execute this view.

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)