Using the database shown below, write the following SQL queries:

a$.$ A query that lists all of the parts in table P $($all columns$)$ that supplier S$2$ carries.

b$.$ A join that lists the part and supplier information for all parts with an available

quantity of $200.$ To simplify your query it is acceptable to list all columns joined

together using $\text{'}*\text{'}.($FOR YOUR JOIN, YOU CAN USE EITHER THE JOIN KEYWORD

OR JUST INCLUDE EACH NEEDED TABLE IN THE FROM SECTION$)$

THE SUPPLIERS$-$AND$-$PARTS DATABASE :

S $\backslash$begin$\{$tabular$\}\{|$l$|$l$|$r$|$l$|\}$

$\backslash$hline SNO & SNAME & STATUS & CITY $\backslash \backslash$

$\backslash$hline $\backslash$hline S$1$ & Smith & $20$ & London $\backslash \backslash$

S$2$ & Jones & $10$ & Paris $\backslash \backslash$

S$3$ & Blake & $30$ & Paris $\backslash \backslash$

S$4$ & Clark & $20$ & London $\backslash \backslash$

S$5$ & Adams & $30$ & Athens $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

SP

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|\}$

$\backslash$hline SNO & PNO & QTY $\backslash \backslash$

$\backslash$hline $\backslash$hline S$1$ & P$1$ & $300\backslash \backslash$

S$1$ & P$2$ & $200\backslash \backslash$

S$1$ & P$3$ & $400\backslash \backslash$

S$1$ & P$4$ & $200\backslash \backslash$

S$1$ & P$5$ & $100\backslash \backslash$

S$1$ & P$6$ & $100\backslash \backslash$

S$2$ & P$1$ & $300\backslash \backslash$

S$2$ & P$2$ & $400\backslash \backslash$

S$3$ & P$2$ & $200\backslash \backslash$

S$4$ & P$2$ & $200\backslash \backslash$

S$4$ & P$4$ & $300\backslash \backslash$

S$4$ & P$5$ & $400\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$c$|$l$|\}$

$\backslash$hline PNO & PNAME & COLOR & WEIGHT & CITY $\backslash \backslash$

$\backslash$hline $\backslash$hline P$1$ & Nut & Red & $12\mathrm{.}0$ & London $\backslash \backslash$

P$2$ & Bolt & Green & $17\mathrm{.}0$ & Paris $\backslash \backslash$

P$3$ & Screw & Blue & $17\mathrm{.}0$ & Oslo $\backslash \backslash$

P$4$ & Screw & Red & $14\mathrm{.}0$ & London $\backslash \backslash$

P$5$ & Cam & Blue & $12\mathrm{.}0$ & Paris $\backslash \backslash$

P$6$ & Cog & Red & $19\mathrm{.}0$ & London $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Paragraph