Database:$$ jwestfal$\_$office

$$

Create a STYLED Webpage that displays the following SQL statements $($php$)$:

$$

$1.$Output each region, and the location$($s$)$ therein, and the address for each location in the region.$*$

$*$Use This SQL for Question $1$ above to avoid a cross$-$product result:

$$

SELECT regions.REGION$\_$ID$,$ regions.REGION$\_$NAME, countries.COUNTRY$\_$ID$,$ countries.REGION$\_$ID$,$ countries.COUNTRY$\_$NAME, locations.COUNTRY$\_$ID$,$ locations.STREET$\_$ADDRESS, locations.CITY, locations.POSTAL$\_$CODE

FROM regions, countries, locations

WHERE regions.REGION$\_$ID $=$ countries.REGION$\_$ID AND countries.COUNTRY$\_$ID $=$ locations.COUNTRY$\_$ID

$$

$2.$ Create a table that outputs each job title and the min and max salary for each

job.

$3.$ Output each department and the department manager.

$4.$ Create a phone list for all employees in the company.