For instructions on how to query a database, see
http://www.w3schools.com/sql/sql_intro.asp
. Also, try running through this tutorial:
https://developer.android.com/courses/pathways/android-basics-compose-unit-6-pathway-1
To find out what columns are available to query on, query "show columns from
table_name
".
Query:
SELECT
SHOW
FROM
Australia
Canada
GreatBritain
International
Ireland
NewZealand
SHHS
SouthAfrica