Questions

1. US states:
   • Find the first-degree neighbors of Colorado (code CO):
     • What are the codes of these neighbors?
     • Can you count how many there are using an aggregate function?
   • Which states have the highest number of neighbors? The lowest? Think about the ORDER BY clause.
2. GitHub graph enhancement:
   
   • From neo4j_repos_github.json, can you save the project language when provided, as a new node? You can use the new Language node label.
   • Can you also save the license, when provided, using a new node? Use a Licence node label and save all of the provided information from GitHub as properties.
     (Hint: the license is provided with the following format):

   "license": {
      "key": "other",
      "name": "Other",
      "spdx_id": "NOASSERTION",
      "url": null,
      "node_id": "MDc6TGljZW5zZTA="
    },

1. • Using the GitHub API, can you save the user locations?
     Hint: the URL to get user information is https://api.github.com/users/<login>.
   • The location often contains the city and country name, separated by either a space or a comma. Can you write a query to save only the first element of this pair, assumed to be the city?
     Hint: checkout APOC text utils.
   • Using the GitHub API, can you retrieve the repositories owned by each Neo4j contributor?
     Hint: the URL to get the repositories for a given user is https://api.github.com/users/<login>/repos.
   • Which location is the most represented among Neo4j contributors?