Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select seximportancepersonal as "Importance of sex to the respondent", count(seximportancepersonal) as "Number of respondents" from furrypoll2012 where animal_<species> = 'o' group by seximportancepersonal;
- Huskies:
- +-------------------------------------+-----------------------+
- | Importance of sex to the respondent | Number of respondents |
- +-------------------------------------+-----------------------+
- | | 2 |
- | 1 | 51 |
- | 10 | 16 |
- | 2 | 22 |
- | 3 | 33 |
- | 4 | 23 |
- | 5 | 22 |
- | 6 | 26 |
- | 7 | 17 |
- | 8 | 16 |
- | 9 | 10 |
- +-------------------------------------+-----------------------+
- Red foxes:
- +-------------------------------------+-----------------------+
- | Importance of sex to the respondent | Number of respondents |
- +-------------------------------------+-----------------------+
- | | 2 |
- | 1 | 67 |
- | 10 | 17 |
- | 2 | 41 |
- | 3 | 51 |
- | 4 | 30 |
- | 5 | 42 |
- | 6 | 30 |
- | 7 | 38 |
- | 8 | 27 |
- | 9 | 14 |
- +-------------------------------------+-----------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement