r/SQL•
Iaintnodemon

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

Oracle

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
Loading comments…