(Solved): Provide the full SQL statement and the result table for each question PLEASE. The tables are attache ...

J \begin{tabular}{|l||l||l|} \hline j_num & jname & \multicolumn{1}{|c|}{ city } \\ \hline$j11$ & Sorter & Paris \\ \hline $\mathrm{j}2$ & Punch & Rome \\ \hline$j\mathrm{j}3$ & Reader & Athens \\ \hline$j\mathrm{j}4$ & Console & Athens \\ \hline $\mathrm{j}5$ & Collator & London \\ \hline $\mathrm{j}6$ & Terminal & Oslo \\ \hline$j\mathrm{j}7$ & Tape & London \\ \hline \end{tabular} P \begin{tabular}{|l|l|l|l||l|} \hline Q ${}_{\text{non }}$ num & pname & color & weight & city \\ \hline $\mathrm{p}1$ & Nut & Red & 12 & London \\ \hline $\mathrm{p}2$ & Bolt & Green & 17 & Paris \\ \hline $\mathrm{p}3$ & Screw & Blue & 17 & Rome \\ \hline $\mathrm{p}4$ & Screw & Red & 14 & London \\ \hline $\mathrm{p}5$ & Cam & Blue & 12 & Paris \\ \hline $\mathrm{p}6$ & Cog & Red & 19 & London \\ \hline \end{tabular} S \begin{tabular}{|l|l|r||l|} \hline S num & S. name & status & city \\ \hline s 1 & Smith & 20 & London \\ \hline s2 & Jones & 10 & Paris \\ \hline s3 & Blake & 30 & Paris \\ \hline s4 & Clark & 20 & London \\ \hline s5 & Adams & 30 & Athens \\ \hline \end{tabular} SPJ