can you help write the query for the table.

2. project.php: Create a PHP file similar to that of employee.php or department.php, call it project.php, which will allow a user to select a project location via a dropdown menu. Then, the PHP file will process the request such that it will execute a SQL query which will, for every project located in the selected project location via the dropdown menu, retrieve the project name, the controlling department name and the department manager's last name, address and birth date. Then, the PHP file will display the results in tabular format. A sample output is shown below. Hint: to include a string literal (e.g. Plocation) in the SQL statement in PHP, you can enclose it in single quotes. Example: When selecting the Bellaire as a project location, the page would display the following results pertaining to the information about all projects having this selected location (e.g. Bellaire): Select a project's location Select a location Select a location Belar Houston Stafford Sugarland assign4 Home Employee Department Project Search Search Select a project's location Select a location Project Name Manager's Last Name Manager's Address Manager's Birth Date Department Number Research Products Wong 638 Voss, Houston, TX 1955-12-08 Example: When selecting the Stafford as a project location, the page would display the following results pertaining to the information about all projects having this selected location (e.g. Stafford): Select a project's location Select a location Select a location Bellaire Houston Stafford Sugarland assign Home Employee Department Project Search Search Select a project's location Select a location Project Name Department Number Manager's Last Name Manager's Address Manager's Birth Date Computerization Administration Wallace 291 Berry, Bellaire, TX 1941-06-20 Newbenefits Administration Wallace 291 Berry, Bellaire, TX 1941-06-20