Mam isme kya issue hai # Write your MySQL query statement below select P.product_id, round(AVG(P.price),2) AS average_price from Prices AS P left join UnitsSold AS U using (product_id) group by P.product_id order by AVG(P.price) ASC;
@ChetanAdivinnavar4 ай бұрын
You make things look easy
@StartPracticing4 ай бұрын
Thanks
@vinamrasangal84364 ай бұрын
@@StartPracticing literally u make it easy
@purushottammitra12584 ай бұрын
Awesome!! Keep it Up👍👍
@StartPracticing4 ай бұрын
Thank you
@pumpkin22285 ай бұрын
ifnull or if null . dono word ke bich gap nahi rahega ?
@mohammadrahil76193 ай бұрын
why we are using left join
@yathansh62663 ай бұрын
as we want all of the data from the prices table, even if there is no instance of that product in the unitsSold data, we still have to display a zero
@Karanchaudhary286 ай бұрын
by using this getting error of test table doesn't exist
@StartPracticing6 ай бұрын
Check your spelling of the table name. Or send me your code or error in Instagram