IN checks if a value matches any item in a list or group, like a quick way to compare.Get the IDs of users who are not admins and belong to specific countries.whereHas filters results based on a related model, while whereNotIn excludes results matching values in a list.COUNT() counts items in a set, and BETWEEN filters values within a specified range.