Id | Name | Cost | Office_Id |
---|---|---|---|
123 | Claxton Renovation | 105000 | 37996 |
Offices
Id | City | State | Street_Address | Phone_Number |
---|---|---|---|---|
37996 | Knoxville | TN | 1119 Volunteer Blvd | 865-974-1000 |
EmployeeProjects
Employee_Id | Project_Id |
---|---|
783 | 123 |
783 | 875 |
EmployeeInfo
Id | Name | Area_Code | Phone | Office_Id | salary | |
---|---|---|---|---|---|---|
783 | Hercules | herc@buildit.com | 423 | 789-1393 | 32030 | 25000 |
You can create example tables to test your queries on by copying the script /home/bvz/cs594/hw/hw9/createProjects.php to your homework directory, editing the $database, $username, and $password strings, and then executing the script (remember to execute it on a cetus or hydra machine--other machines in the department do not have the php mysql module installed).
Write the following SQL queries (do not worry about upper/lower case) and put your answers in a file named answers.txt:
Average project cost = $xxxxx.xx
The only important thing about the output is that it be restricted to two decimal digits.
The problem requirements are as follows: