JKISeason 4-19 - Pokemon Local Database

<p><strong>Challenge 19: Pokemon 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 <strong>Season 3</strong>, 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, and then created <em>pokemonAPI_Local.sqlite</em>: 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 <strong>KNIME Database extension</strong> in your solution.<br><br><strong>Author:</strong> <strong>Yasue Katsutaka</strong><br><br><strong>Dataset:</strong> <strong>Pokémon Database on KNIME Community Hub</strong><br><br>Remember to upload your solution with tag&nbsp;<strong>JKISeason4-19</strong>&nbsp;to your public space on KNIME Community Hub. To increase the visibility of your solution, also post it to&nbsp;<strong>this challenge thread</strong>&nbsp;on KNIME Forum.</p>