Run this query as rs1:
select distinct scary_words from monsters_table;
String word;
String query;
Int count;
while rs1.next() {
word = rs1.getString();
// Run this query as rs2
query = 'select count(*) from monster_table where scary_words="' +
word + '"';
Run this query as rs1:
select distinct scary_words from monsters_table;
String word;
String query;
Int count;
while rs1.next() {
word = rs1.getString();
// Run this sql query as rs2
query = 'select count(*) from monster_table where scary_words="' +
word + '"';
