16. Average Selling Price | SQL Leetcode | SQL Interview Questions and Answers

[@sahid_parvej]

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;

[@ChetanAdivinnavar]

You make things look easy

[@StartPracticing]

Thanks

[@vinamrasangal8436]

@@StartPracticing literally u make it easy

[@purushottammitra1258]

Awesome!! Keep it Up👍👍

[@StartPracticing]

Thank you

[@pumpkin2228]

ifnull or if null . dono word ke bich gap nahi rahega ?

[@mohammadrahil7619]

why we are using left join

[@yathansh6266]

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

[@Karanchaudhary28]

by using this getting error of test table doesn't exist

[@StartPracticing]

Check your spelling of the table name. Or send me your code or error in Instagram