gistfile1.txt

mysql> select donor_side_name,count(*) from disclosures group by donor_side_name order by count(*) desc;
+------------------+----------+
| donor_side_name  | count(*) |
+------------------+----------+
| NULL             |        8 |
| Chloe Cockburn   |        8 |
| Nick Beckstead   |        7 |
| Lewis Bollard    |        7 |
| Alexander Berger |        6 |
| Howie Lempel     |        4 |
| Paul Christiano  |        4 |
| Daniel Dewey     |        3 |
| Dario Amodei     |        3 |
| Luke Muehlhauser |        3 |
| Holden Karnofsky |        3 |
| Carl Shulman     |        2 |
| Helen Toner      |        2 |
| Jacob Steinhardt |        2 |
| Kevin Esvelt     |        2 |
| Claire Zabel     |        1 |
| Chris Olah       |        1 |
| Jaime Yassif     |        1 |
| Adam Marblestone |        1 |
+------------------+----------+
19 rows in set (0.01 sec)

mysql> select relationship_nature,count(*) from disclosures group by relationship_nature order by count(*) desc;
+-----------------------+----------+
| relationship_nature   | count(*) |
+-----------------------+----------+
| Professional          |       37 |
| Personal              |       10 |
| Friendship            |       10 |
| Social                |        5 |
| Romantic relationship |        4 |
| Academic              |        1 |
| Marriage              |        1 |
+-----------------------+----------+
7 rows in set (0.00 sec)

mysql> select count(*) from disclosures;
+----------+
| count(*) |
+----------+
|       68 |
+----------+
1 row in set (0.00 sec)

mysql> select donee_side_name,count(*) from disclosures group by donee_side_name order by count(*) desc;
+-------------------+----------+
| donee_side_name   | count(*) |
+-------------------+----------+
| NULL              |       22 |
| Paul Christiano   |        5 |
| Thomas Kelly      |        4 |
| Josh Morrison     |        4 |
| Nate Soares       |        3 |
| Daniel Dewey      |        3 |
| Wayne Pacelle     |        2 |
| Dario Amodei      |        2 |
| Julia Galef       |        2 |
| Adam Marblestone  |        2 |
| Chloe Cockburn    |        2 |
| Jacob Steinhardt  |        2 |
| Rob Smith         |        1 |
| Josh Balk         |        1 |
| Ed Boyden         |        1 |
| Tom Inglesby      |        1 |
| Vincent Schiraldi |        1 |
| Kevin Esvelt      |        1 |
| Anna Salamon      |        1 |
| Carl Shulman      |        1 |
| David Keith       |        1 |
| Yoshua Bengio     |        1 |
| Danielle Sered    |        1 |
| Paul Shapiro      |        1 |
| Luke Muehlhauser  |        1 |
| David Krueger     |        1 |
| Jon Wool          |        1 |
+-------------------+----------+
27 rows in set (0.00 sec)