Icon

08 Database Data Manipulation - Solution

08 Database Data Manipulation - Solution
Exercise: Database Data Manipulation1) Execute the metanode below. It writes the joined table containing demographics,travel advisory, and geocoordinates information into a SQLite database. 2) Select the JoinedTable table on the database3) Calculate the number of rows (countries) in the database table4) Filter the table to countries where the maximum overall life expectancy is > 805) Calculate the numbers of countries with life expectancy >80 in each travel riskcategory. What is the most common category among these countries? How manycountries belong to the risk category 3 (Reconsider travel)? Count of rowsFilter rows where max LE> 80Counts by risk levels DB Table Selector DB GroupBy DB Row Filter DB GroupBy Write joineddata to database Exercise: Database Data Manipulation1) Execute the metanode below. It writes the joined table containing demographics,travel advisory, and geocoordinates information into a SQLite database. 2) Select the JoinedTable table on the database3) Calculate the number of rows (countries) in the database table4) Filter the table to countries where the maximum overall life expectancy is > 805) Calculate the numbers of countries with life expectancy >80 in each travel riskcategory. What is the most common category among these countries? How manycountries belong to the risk category 3 (Reconsider travel)? Count of rowsFilter rows where max LE> 80Counts by risk levelsDB Table Selector DB GroupBy DB Row Filter DB GroupBy Write joineddata to database

Nodes

Extensions

Links