|37996||Knoxville||TN||1119 Volunteer Blvd||865-974-1000|
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: