Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Remove duplicate instructor listings #23

Open
nathanmsmith opened this issue Nov 13, 2022 · 0 comments
Open

Remove duplicate instructor listings #23

nathanmsmith opened this issue Nov 13, 2022 · 0 comments

Comments

@nathanmsmith
Copy link
Member

There are some duplicate instructor listings:

select id, first_names, last_names from instructors where first_names in (select first_names from instructors group by first_names, last_names having count(*) > 1) and last_names in (select last_names from instructors group by first_names, last_names having count(*) > 1) and array_length(first_names,1) > 0 order by first_names, last_names;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant