how to change this code

Question

SELECT DATE(A.Inspection_datetime) AS Date,  
  A.Model,  
  COUNT(A.Serial_number) AS Qty,  
  B.Name  
FROM inspection_report AS A  
LEFT JOIN Employee AS B ON A.NIK = B.NIK  
 GROUP BY A.Model, A.Serial_number 

Answer 1

At a guess (and believe me, I'm guessing)

SELECT DATE(A.Inspection_datetime) AS Date,   
  A.Model,   
  COUNT(A.Serial_number) AS Qty,   
  B.Name   
FROM inspection_report AS A   
LEFT JOIN Employee AS B ON A.NIK = B.NIK   
 GROUP BY A.Model, B.Name   

You need to group by the fields you're not aggregating