Mr$.$ Fitte would like to know the average gym membership fee paid by Wellesley vs$.$ Lexington residents.

Requirement: Use one wildcard and format results as US currency with two decimal places.

Hint: Use the following to build this query...

Group By $($or Totals$)$

Criteria $($this is where you can use the wild card $*)$

Calculation $($remember to factor in the discount$)$

Average function $($located in the same place that you find Sum and Count$)$

Once you have your calculation, you can format according to the required specs noted above by going into design view, right clicking on the calculated field, selecting properties. In the panel that now appears on the right, set your format as follows: change format to currency and decimal places to $2.$

Your results should look like this:

Optional: Practice Queries

$($See Canvas or ask Professor$)$

Collins Lighting Queries and Solutions

Fitness Peddlers Queries and Solutions

Need help with queries?

peertutoring@babson.edu is available to assist!