Rakesh Keerthi wrote:...
This is an SQLException and it's reporting an invalid column name, so I'd start by looking at the column names in your SQL. Is "Couunt1" a valid column name? How about the others? Also, you are not fetching the query_answered column in your outer SELECT, and why is your SQL nested anyway?
Take your SQL query and
test it in your SQL interpreter shell before you put it into
Java. That way you can be sure the query is correct.