By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
RespondentID | LastName | FirstName |
---|---|---|
1 | Charming | Prince |
2 | Doe | Jane |
3 | Fisher | Kenneth |
4 | Smith | Bob |
QuestionID | Question |
---|---|
1 | What is your first name? |
2 | What is your favorite color? |
3 | What do you do for a living? |
4 | What is 4x7? |
5 | What is 1235x523 |
6 | What is 2x3 |
7 | What is 3/4 |
8 | What is 7x6 |
9 | Why? |
FirstName | LastName | Question1 | Answer1 | Question2 | Answer2 | Question3 | Answer3 | Question4 | Answer4 | Question5 | Answer5 |
---|---|---|---|---|---|---|---|---|---|---|---|
Kenneth | Fisher | What is your first name? | Kenneth | What is your favorite color? | green | What do you do for a living? | Not much | What is 2x3 | 6 | Why? | Because |
Bob | Smith | What is your first name? | Robert | What is your favorite color? | blue | What is 4x7? | 238 | What is 7x6 | Life the Universe and Everything | Why? | Why not |
Jane | Doe | What is your first name? | John | What is your favorite color? | plaid | What do you do for a living? | Door to door salesman | What is 3/4 | .75 | Why? | yes |
Prince | Charming | What is your first name? | George | What is your favorite color? | Orange | What do you do for a living? | Not much | What is 1235x523 | Yea right | Why? | no |
RespondentID | QuestionID | Answer |
---|---|---|
1 | 1 | George |
1 | 2 | Orange |
1 | 3 | Not much |
1 | 5 | Yea right |
1 | 9 | no |
2 | 1 | John |
2 | 2 | plaid |
2 | 3 | Door to door salesman |
2 | 7 | .75 |
2 | 9 | yes |
3 | 1 | Kenneth |
3 | 2 | green |
3 | 3 | Not much |
3 | 6 | 6 |
3 | 9 | Because |
4 | 1 | Robert |
4 | 2 | blue |
4 | 4 | 238 |
4 | 8 | Life the Universe and Everything |
4 | 9 | Why not |