Advertisement
makyo

Untitled

Aug 20th, 2013
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.13 KB | None | 0 0
  1. select seximportancepersonal as "Importance of sex to the respondent", count(seximportancepersonal) as "Number of respondents" from furrypoll2012 where animal_<species> = 'o' group by seximportancepersonal;
  2.  
  3. Huskies:
  4. +-------------------------------------+-----------------------+
  5. | Importance of sex to the respondent | Number of respondents |
  6. +-------------------------------------+-----------------------+
  7. | | 2 |
  8. | 1 | 51 |
  9. | 10 | 16 |
  10. | 2 | 22 |
  11. | 3 | 33 |
  12. | 4 | 23 |
  13. | 5 | 22 |
  14. | 6 | 26 |
  15. | 7 | 17 |
  16. | 8 | 16 |
  17. | 9 | 10 |
  18. +-------------------------------------+-----------------------+
  19.  
  20. Red foxes:
  21. +-------------------------------------+-----------------------+
  22. | Importance of sex to the respondent | Number of respondents |
  23. +-------------------------------------+-----------------------+
  24. | | 2 |
  25. | 1 | 67 |
  26. | 10 | 17 |
  27. | 2 | 41 |
  28. | 3 | 51 |
  29. | 4 | 30 |
  30. | 5 | 42 |
  31. | 6 | 30 |
  32. | 7 | 38 |
  33. | 8 | 27 |
  34. | 9 | 14 |
  35. +-------------------------------------+-----------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement