Consider the table given and answer the following questions.

$1$: Describe the SQL filters. Give one or two examples to show how SQL statements will

filter or retrieve the asked columns and rows.

$2$: Briefly describe how $$GROUP BY$$ and $$HAVING$$ works. Give your own examples. Do

not use the same examples from the class.

Write down $($or Type$)$ the SQL statements for the following queries.

$1$: Create the above$-$mentioned Table. Keep the same name. $**$ means that it is a primary key.

$2$: Show the peoples who are from $$Canada$$ and NOT $$Married$.$

$3$: Show the average $($AVG$),$ highest $($MAX$)$ and smallest $($MIN$)$ age from the database.