So i was giving some test and my expected output was around 15 lines and my output was 16 lines with last line empty but it was 16
SELECT a.name, a.price, COUNT(b.product_id) AS total_wishcount from wishlists b JOIN products a ON b.product_id = a.id where a.in_stock != 0 GROUP BY a.name, a.price ORDER BY a.name ASC; What did i do wrong here
Posted Oct 6, 2025, 7:07 PM UTC
214