Under the object explorer in SQL it's showing me about 5-10 columns but they all say "non-unique, non-clustered". When I go into design view of the table > indexes it shows me about 8-10 fields ...

Expected answers and my own solutions for the Subqueries section in "Joining Data in SQL." - hshehjue/SQL-DataCamp ...

A SELECT group of programmers with a DISTINCT advantage If you’re still with us, congratulate yourself—you survived the second part of our series on SQL basics!