CodeFriends
Eliminate duplicates and use aliases in SQL with DISTINCT and AS.
Use DISTINCT with aggregate functions and understand nested queries.