States with similar sizes
You're given a table showing the total area (in square miles) of 50 U.S. states. Preview below:
Using this table, write a SQL query to grab pairs of states with total land area within 100,000 square miles of each other. For the snippet above, we would want to see something like:
You can view/query the table in an interactive SQL fiddle here.
Subscribe to premium account to see the solution.Get premium now