SQL can be very simple

Assume you’d like to see all the distinct States that have Cities and Towns above 9,000 feet on the right. We can do this easily in SQL:

SELECT DISTINCT State

FROM database_table

  • The DISTINCT keyword returns each unique, distinct value within a column so it will return: Colorado, Utah, New Mexico, and Arizona essentially returning everything in the State column and removing duplicates (similar to that same remove duplicates function in Excel).