✘✘✘ Database1 Join 3 tables > group by > COUNT > How to show 0? count the number of SELLING CAR_ID 1000 sold at each BRANCH: if a BRANCH did not sell any 1000 CAR_ID, PRINT 0 SELCT: employee join branch left join sellings I want to count the number of cars sold at each branch where CAR_ID is 1000 If there is no car sold at a branch, I need to print out 0. select s.id as SELLING_ID, s.car_id as CAR_ID, e.id as EMPLOYEE_ID, -- COUNT(s.id), b.id as BRANCH_ID, b.. 2022. 11. 26. 이전 1 다음
