Hi, I need help with SQL code there is question also add my work to what is wrong

Hi, I need help with SQL code there is question also add my work to what is wrong.

src=”/qa/attachment/3324539/” alt=”1.png” /> ATTACHMENT PREVIEW Download attachment

1.png

1. In a single SELEET query, from the e_store.products
table:
Displayr the product with the least stock aliasing the
column name as: 1east_5tock , the newest product aliasing the column name as: neues‘l:_produc‘l: and the most expensive product aliasing the column name as: product_lax_price _ The output should look like this: + ————————————— + ———————————————————— + ——————————————————— +
I 1ea5t_stock I newe5t_product I product_max_price I
+ ————————————— + ———————————————————— + ——————————————————— +
I 1 I 2315—15—33 55:35:33 I 157 4-H I
+ ————————————— + ———————————————————— + ——————————————————— + 1 row in set {H.fl1 sec} l[Illnce you have completed these tasks press the Check It! button to have 1Irour solution assessed. Check It! LAST RUN on 4I1¢l2tlla Loads
[Error]: Task 1. Expected: Get the requested data in a single select query My wk select HINflstook] A5 least_stookI
HAI[produots] A5 newsst_productll
HAK[Price] AS product_max_price
FRDH e_store.products;

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"