- 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.
- Find the first-degree neighbors of Colorado (code CO):
- 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="
},
-
- Using the GitHub API, can you save the user locations?
Hint: the URL to get user information...
- Using the GitHub API, can you save the user locations?