$1.$ Display the product code, product description, and product price for products provided by vendor $21344.$ Do NOT use the $*$ here but list specific attributes and also use the WHERE clause.

$2.$ Display all product information for products currently selling for less than $$50\mathrm{.}00$ and which came in between $01/01/2022$ and $01/20/2022($inclusive$).$ Use the TO $\_$DATE$(01/$JAN$/2022,$dd$/$mon$/$yyyy$)$ function and the between keyword $($between x and y$).$ You will use the $*$ for all attributes and also the AND keyword. $[$hint: you should have $5$ rows of output$].$

$3.$ Display the product code, product description, price and price after discount $($a computed column that uses the P$\_$PRICE and P$\_$DISCOUNT $[$a percent discount$]$ to be named with an alias of DiscountPrice $[...$ AS DiscountPrice$])$ for products for which a vendor is specified in table PRODUCT. You will specify attribute names in the SELECT and use the WHERE clause for this query. $[$hint: you should have $14$ rows of output$].$

$4.$ Display the product code, product description, product price, vendor code and vendor name for products provided by vendors located in the state of Tennessee. Since the attributes required for this query come from $2$ separate tables, you will need to include those in your FROM clause and also join those $2$ tables together using the PK$/$FK pairs WHERE T$1.$C$1=$T$2.$C$1[$refer to the diagram for the proper PK$/$FK from each table$].[$hint: you should have $6$ rows of output$].$

P$\_$CODE P$\_$DESCRIPT P$\_$INDATE P$\_$QOH P$\_$MIN P$\_$PRICE P$\_$DISCOUNT V$\_$CODE

$11$QER$/31$ Power painter, $15$ psi., $3-$nozzle $03-$NOV$-202185109\mathrm{.}99025595$

$13-$Q$2/$P$27\mathrm{.}25$ in$.$ pwr$.$ saw blade $13-$DEC$-2021321514\mathrm{.}99\mathrm{.}0521344$

$14-$Q$1/$L$39\mathrm{.}00-$in$.$ pwr$.$ saw blade $13-$NOV$-2021181217\mathrm{.}49021344$

$1546-$QQ$2$ Hrd$.$ cloth, $14-$in$.,2$x$5015-$JAN$-202215839\mathrm{.}95023119$

$1558-$QW$1$ Hrd$.$ cloth, $12-$in$.,3$x$5015-$JAN$-202223543\mathrm{.}99023119$

$2232/$QTY BD jigsaw, $12-$in$.$ blade $30-$DEC$-202185109\mathrm{.}92\mathrm{.}0524288$

$2232/$QWE BD jigsaw, $8-$in$.$ blade $24-$DEC$-20216599\mathrm{.}87\mathrm{.}0524288$

$2238/$QPD BD cordless drill, $12-$in$.20-$JAN$-202212538\mathrm{.}95\mathrm{.}0525595$

$23109-$HB Claw hammer $20-$JAN$-202223109\mathrm{.}95\mathrm{.}121225$

$23114-$AA Sledge hammer, $12$ lb$.02-$JAN$-20228514\mathrm{.}4\mathrm{.}05-$

$54778-2$T Rat$-$tail file, $18-$in$.$ fine $15-$DEC$-202143204\mathrm{.}99021344$

$89-$WRE$-$Q Hicut chain saw, $16$ in$.07-$FEB$-2022115256\mathrm{.}99\mathrm{.}0524288$

PVC$23$DRT PVC pipe, $3\mathrm{.}5-$in$.,8-$ft $20-$FEB$-2022188755\mathrm{.}870-$

SM$-182771\mathrm{.}25-$in$.$ metal screw, $2501-$MAR$-2022172756\mathrm{.}99021225$

SW$-231162\mathrm{.}5-$in$.$ wd$.$ screw, $5024-$FEB$-20222371008\mathrm{.}45021231$

WR$3/$TT$3$ Steel, $4$x$8$x$16,\mathrm{.}5$ mesh $17-$JAN$-2022185119\mathrm{.}95\mathrm{.}125595$