Each member must have their own email. members has 50 000 rows, and nothing stops two of them from sharing an email yet.
- List the indexes of
members. What is the name of the index behind the primary key? - Try to create a unique index named
members_email_keyonemail. Which email does the error say is duplicated? - Two members share that email. Delete the one with the higher
id. - Create the unique index
members_email_keyonemail. - Try to add member 50001,
monster50001, with the emailuser77@example.com, countryCA, joined2025-07-01. Complete the error: duplicate key value violates ___ "members_email_key".