Finding Top Entity IDs with Largest Row Count Difference Between Tables in MySQL

Using n_distinct to Extract Unique Values by Specific Conditions in R Data Analysis