Refer to the following tables then answer the questions that follow.

Table$1$ Publisher:

$\backslash$table$[[$pub$\_\_$D$,$pub$\_$name,address,city,state$],[736,$New Age Books,$41$st Ave.,Boston,MA$],[877,$Binnet&Barney,$2334$ rd St$.,$Washington,DC$],[1389,,,,]]$

Table $2$ Titles:

$\backslash$table$[[$Title$\_$ID$,$fitle,cat,Pub$\_10,$price$],[2091,$is anger the enemy,psychology,$0736,10\mathrm{.}00],[2106,$Life without fear,psychology,$0736,7\mathrm{.}00],[1035,$alien,sci$-$fi$,1389,19\mathrm{.}99]]$

SOL query $1$:

SELECT pub$\_10,$ pub$\_$name

FROM publisher

WHERE state NOT IN $(\text{'}$MA$\text{'}"$IL$\text{'})$ AND pub$\_$name NOT UKE $\text{'}$AS$\text{'}$

Sal query $2$ :

SELECT cat, AVG$($price$)$ AS Average Price, SUM $($price $+$ price $0\mathrm{.}2)$ AS TotalPrice

FROM titles

GROUP BY cat:

Show the data output produced when each of the following sal queries are executed.