Challenge 19: Pokémon Local Database
Level: Medium
Description: Recently you have been feeling a bit nostalgic about Pokémon and our related challenge from Season 3, and decided to use the PokeAPI to create your own local database of fantastical creatures. Through the API, you retrieved the dataset of each Pokémon and their types, then created "pokemonAPI_Local.sqlite": a local database. Now you want to create a workflow that fetches data from this database and outputs a list of Pokémon types in descending order of frequency. For a little extra challenge, how about automatically retrieving the latest data from the PokeAPI and updating each data table accordingly? Hint: A lot of the processing should happen within the database for efficiency. Please use the KNIME Database extension in your solution.