I have a problem that I've racked my brain with for two weeks without success.
I have a table named 'user_answers' containing columns 'user_answer_id'
and 'user_name'. Each 'user_name' has 25 rows. I'm trying to compare/count
the number of rows where user A and user B match answer_id.
SELECT COUNT (*) user_answer_id FROM user_answers WHERE user_name = Jake LIKE (SELECT user_answer_id FROM user_answers WHERE user_name = Betty)
The above returns 25 rows from Jake. There should only be 6. I've tried substituting LIKE with IN but get every row in the table.
Any help with this would surely be appreciated.