Objective $7$: Create a Query to Calculate the Derived Attributes

Our database needs to calculate a child's age based on their birth date, and automatically

assign them to a league based on their age. These are called "calculated fields" $($derived

attributes$)$ and can't be included in a table's design. So$,$ you'll need to create a query

from the related tables that will display each child's last and first name, the child's Date

of birth $($DOB$),$ and the child's age and league, as shown in the bottom of the form in

Figure $4$ on the last page. Make sure to include the parent id $($PK$)$ in the query so we

know which child belongs to which parent. Name the query CQ$.$ Note the following.

The age must be a calculated field in the query $($using date functions$),$ and returned as

an integer value, like $9$ or $14,$ not $9\mathrm{.}35$ or $14\mathrm{.}22.$

The league assignment must also be a calculated field in the query $($based off an $\text{'}$IF$\text{'}$

type function that determines league by age$).$ For children outside of the age ranges,

the league assignment should simply say "Not Eligible." Save the query as $CQ$ and

close it$.$