Challenge 19 - Pokemon Local Database

<p><strong>Challenge 19: Pokémon Local Database</strong></p><p><strong>Level:</strong> Medium</p><p><strong>Description:</strong> Recently you have been feeling a bit nostalgic about Pokémon and our related challenge from Season 3, and decided to use the <strong>PokeAPI</strong> 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 <strong>PokeAPI</strong> and updating each data table accordingly? <strong>Hint: </strong>A lot of the processing should happen within the database for efficiency. Please use the KNIME Database extension in your solution.</p>