gistfile1.txt

MariaDB [lobsters]> SELECT user_is_author, MIN(score), AVG(score), MAX(score), STDDEV(score) FROM
    ->                     stories GROUP BY user_is_author;
+----------------+------------+------------+------------+---------------+
| user_is_author | MIN(score) | AVG(score) | MAX(score) | STDDEV(score) |
+----------------+------------+------------+------------+---------------+
|              0 |        -22 |    12.3296 |        341 |       16.1358 |
|              1 |         -9 |    15.9859 |        472 |       21.5062 |
+----------------+------------+------------+------------+---------------+

MariaDB [lobsters]> SELECT user_is_author, MIN(score), AVG(score), MAX(score), STDDEV(score), count(*) FROM                     stories GR
OUP BY user_is_author;
+----------------+------------+------------+------------+---------------+----------+
| user_is_author | MIN(score) | AVG(score) | MAX(score) | STDDEV(score) | count(*) |
+----------------+------------+------------+------------+---------------+----------+
|              0 |        -22 |    12.3296 |        341 |       16.1358 |    99535 |
|              1 |         -9 |    15.9859 |        472 |       21.5062 |    23972 |
+----------------+------------+------------+------------+---------------+----------+
2 rows in set (0.152 sec)