0 0 votes Please explain the solution Ans iis given - C Databases + – garg div 558 views answer comment Share Follow Print See all 3 Comments 3 3 Comments reply Anu007 commented Nov 8, 2017 reply Follow flag some part is missing ? 0 0 replyShare SHUBHAM SHASTRI commented Nov 8, 2017 reply Follow flag answer will depend on database instance....say in 2nd case if i put NULL at such a places where RATING are high ...OPTION C can never be correct one ....such question need an instance of DB ...i think so ...... 0 0 replyShare garg div commented Nov 8, 2017 reply Follow flag I think ans is B because they said COUNT not COUNT(*) , as except COUNT(*) all other aggregate function ignore NULL values therefore when sum is divided by count it is equal to avg. Please correct me if my logic is wrong. 0 0 replyShare Please log in or register to add a comment.
