By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| qid | submit_ans | submit_text | correct_ans | correcttext |
|---|---|---|---|---|
| 1 | opt2 | dog | opt2 | dog |
| 2 | opt3 | bat | opt4 | rat |
| 3 | opt4 | lion | opt1 | ice |
| 4 | opt1 | goat | opt3 | kid |
| qid | submit_ans | submit_text | correct_ans | correcttext |
|---|---|---|---|---|
| 1 | opt2 | dog | opt2 | dog |
| 2 | opt3 | bat | opt4 | rat |
| 3 | opt4 | lion | opt1 | ice |
| 4 | opt1 | goat | opt3 | kid |