The following query results in $2,698$ rows of data being retrieved, but the auditor$\_$report table only has $1,620$ rows. Analyse the query and select the reason why this discrepancy occurs. Hint: Think about the type of relationship between our tables. SELECT auditorRep.location$\_$id$,$ visitsTbl.record$\_$id$,$ Empl$\_$Table.employee$\_$name, auditorRep.true$\_$water$\_$source$\_$score AS auditor$\_$score, wq$.$subjective$\_$quality$\_$score AS employee$\_$score FROM auditor$\_$report AS auditorRep JOIN visits AS visitsTbl ON auditorRep.location$\_$id $=$ visitsTbl.location$\_$id JOIN water$\_$quality AS wq ON visitsTbl.record$\_$id $=$ wq$.$record$\_$id JOIN employee as Empl$\_$Table ON Empl$\_$Table.assigned$\_$employee$\_$id $=$ visitsTbl.assigned$\_$employee$\_$id;