Skip to content

Instantly share code, notes, and snippets.

@blockjon
Last active December 22, 2015 06:19
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save blockjon/6430052 to your computer and use it in GitHub Desktop.
Save blockjon/6430052 to your computer and use it in GitHub Desktop.
The correct results set for problem #1 in our SQL challenge.
+----+-------+-------------------------------+
| id | name | total_cold_inquiries_received |
+----+-------+-------------------------------+
| 2 | Mike | 1 |
| 4 | Bill | 2 |
| 5 | Kate | 1 |
| 6 | Sue | 1 |
| 7 | Linda | 2 |
| 8 | Mary | 1 |
+----+-------+-------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment