INSERTINTO tmp_table SELECT'Asia'AS'continent',COUNT(*) FROM country WHERE continent ='Asia'; INSERTINTO tmp_table SELECT'North America'AS'continent',COUNT(*) FROM country WHERE continent ='North America'; INSERTINTO tmp_table SELECT'Europe'AS'continent',COUNT(*) FROM country WHERE continent ='Europe'; INSERTINTO tmp_table SELECT'South America'AS'continent',COUNT(*) FROM country WHERE continent ='South America'; INSERTINTO tmp_table SELECT'Oceania'AS'continent',COUNT(*) FROM country WHERE continent ='Oceania'; INSERTINTO tmp_table SELECT'Antarctia'AS'continent',COUNT(*) FROM country WHERE continent ='Antarctia';