This should run in postgres.

In a single SQL script file ending in $.$sql:

$-$ Create a COMPANY database. This should be part of your SQL script, and you may add a DROP DATABASE command before it so that you can re$-$run your script as many times as you like.

$-$ Create tables that match the schema in figure $5\mathrm{.}6,$ the COMPANY database in your book. Include all necessary constraints.

$-$ Add new tables to track expenses by employees and paychecks to employees.

$-$ Insert matching information to the data seen in the book so that the queries you write will match.

a$.$ Retrieve the names of all employees in department $5$ who work morethan $10$ hoursList the names of all employees who have a dependent with the same first

name as themselves.

b$.$ List the names of all employees who have a dependent with the same first name as themselves.

c$.$ Find the names of all employees who are directly supervised by $$Franklin Wong$.$