Question $6(1$ point$)$

Choose all the optional query block in "Select "retrieval query?

Select

Where

From

Order By

Question $7(5$ points$)$

You work for a bank, which also gives home mortgages to its clients. Your team is asked to use Nearest Neighbor approach to make this decision for an important client John$\_$Jill.

In the table below, your team has calculated the distance of John$\_$Jill from other neighbors. Your team used Income, Residence and Act$\_$balance to calculate the distance $($Do not worry about the actual value of the variable. Only focus on the distance$)$

Part $1)(2$ points$)$ If you use $5$ NN $,$ what will be your decision? Why?

Part $2)(2$ points$)$If you used $4$ NN $,$ what will be decision? Why?

Pact $3)(1$ point$)$ Can you come up with a solution to provide a concrete answer for Part $2?$

$\backslash$table$[[\backslash$table$[[$Income$],[$Residence$]],\backslash$table$[[$Account BalanceMortage$],[$Distance$]]],[$John$\_$Jilli,,r$1,$a $1,??,],[$John$\_$A i$,,$r$2,$a $2,$Yes,$500],[$John$\_$B i$,3,$r$3,$a$3,$Yes,$100],[$Jill$\_$A$,$i$4,$r$4,$a $4,$No$,300],[$Jill$\_$B$,5,$r$5,$a$5,$No$,1200],[$Sam$,$i$6,$r$6,$a$6,$No$,700]]$