dolution

For each question, provide me with a screenshot of the query and its result in MySQL.

1. Find a query that shows attributes ChooseName1, ChooseName3, and ChooseNameNum (only when there is a match on ChooseName2 between Tables A and B).
2. Find a query that shows the same list as the question above but also ChooseName3 and its value when there is no match with Table A. (normally in individual Assignment 3, you entered instances in Table B that are not matched in Table A. If not, please do it now).
3. Find a query that returns the same as question a. but only for ChooseNameNum values that are greater than the average of ChooseNameNum.