Challenge 19 - Pokémon Local Database_​PV

<p><strong>Challenge 19 - Pokémon Local Database</strong></p><p><strong>Level:</strong> Medium<br><br><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.</p>