User:Staeiou/Journal/SharedIP
< User:Staeiou | Journal
All IP addresses[edit]
Outcome metrics[edit]
mysql> select isarchived, header_template, count(*), avg(edits_before_dec15) as avg_edits_before, avg(edits_after_dec15) as avg_edits_after, avg(reverts_before_dec15) as avg_reverts_before, avg(reverts_after_dec15) as avg_reverts_after, avg(reverts_after_dec15/edits_after_dec15) as prop_reverts, avg(registrations) as avg_registrations, avg(registrations/edits_before_dec15) as `registrations/before_edits` from sharedip_all group by 1,2 order by 2,1; +------------+----------------------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ | isarchived | header_template | count(*) | avg_edits_before | avg_edits_after | avg_reverts_before | avg_reverts_after | prop_reverts | avg_registrations | registrations/before_edits | +------------+----------------------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ | 0 | NULL | 2861 | 114.7697 | 0.4547 | 7.4505 | 0.0259 | 0.02925714 | 0.0409 | 0.00026760 | | 1 | NULL | 15 | 108.8667 | 0.0000 | 6.6000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 0 | Dynamic_IP | 2 | 35.5000 | 0.0000 | 2.5000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 1 | Dynamic_IP | 1 | 318.0000 | 0.0000 | 17.0000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 0 | ISP | 1737 | 31.8803 | 2.9781 | 3.0317 | 0.1900 | 0.06798598 | 0.1157 | 0.00189974 | | 1 | ISP | 122 | 93.9754 | 1.1557 | 6.0410 | 0.0164 | 0.00426429 | 0.0656 | 0.00035492 | | 0 | ISP_test | 714 | 25.9622 | 1.0980 | 2.5042 | 0.0378 | 0.03222532 | 0.1064 | 0.00397580 | | 1 | ISP_test | 13825 | 61.9865 | 0.9825 | 4.5776 | 0.0433 | 0.03195978 | 0.0559 | 0.00121037 | | 0 | Mobile_IP | 72 | 94.5000 | 4.1389 | 8.2083 | 0.1528 | 0.06497692 | 0.6111 | 0.01416212 | | 1 | Mobile_IP | 280 | 51.6679 | 1.0929 | 5.3786 | 0.0786 | 0.04597353 | 0.2036 | 0.00353732 | | 0 | Shared_IP | 14187 | 93.6779 | 2.0221 | 6.0900 | 0.0666 | 0.03218299 | 0.0968 | 0.00146635 | | 1 | Shared_IP | 3586 | 211.8107 | 2.8391 | 13.8196 | 0.0931 | 0.03561518 | 0.2317 | 0.00134716 | | 0 | Shared_IP_address_(public) | 171 | 160.1579 | 6.0117 | 12.5965 | 0.0819 | 0.02838409 | 0.1462 | 0.00030542 | | 1 | Shared_IP_address_(public) | 312 | 171.1410 | 2.6026 | 10.0224 | 0.0417 | 0.03776957 | 0.0994 | 0.00091410 | | 0 | Shared_IP_corp | 343 | 243.5219 | 12.8921 | 20.2536 | 1.3586 | 0.02191651 | 0.4606 | 0.00618469 | | 1 | Shared_IP_corp | 385 | 177.2909 | 5.4026 | 11.7688 | 0.3584 | 0.04344845 | 0.4000 | 0.00951403 | | 0 | Shared_IP_corp_test | 1 | 336.0000 | 9.0000 | 22.0000 | 0.0000 | 0.00000000 | 0.0000 | 0.00000000 | | 1 | Shared_IP_corp_test | 6 | 672.8333 | 41.5000 | 46.1667 | 2.0000 | 0.03310000 | 3.0000 | 0.00190000 | | 0 | Shared_IP_edu | 63 | 315.4127 | 1.8571 | 16.3651 | 0.0000 | 0.00000000 | 0.0952 | 0.00032857 | | 1 | Shared_IP_edu | 1 | 67.0000 | 16.0000 | 3.0000 | 0.0000 | 0.00000000 | 0.0000 | 0.00000000 | | 0 | Shared_IP_test | 79 | 28.2152 | 0.9367 | 1.5190 | 0.0380 | 0.04807692 | 0.1392 | 0.00540769 | | 1 | Shared_IP_test | 191 | 63.4346 | 2.6126 | 5.1623 | 0.0838 | 0.01895227 | 0.3246 | 0.01092063 | | 0 | SingNet | 117 | 90.5299 | 1.7179 | 5.7607 | 0.0342 | 0.02436875 | 0.2393 | 0.00367872 | | 1 | SingNet | 14 | 180.5714 | 3.1429 | 12.3571 | 0.0000 | 0.00000000 | 0.6429 | 0.00946429 | | 0 | Whois | 6 | 475.8333 | 42.8333 | 34.0000 | 0.1667 | 0.00136667 | 0.3333 | 0.00060000 | +------------+----------------------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+
mysql> select isarchived, count(*), avg(edits_before_dec15) as avg_edits_before, avg(edits_after_dec15) as avg_edits_after, avg(reverts_before_dec15) as avg_reverts_before, avg(reverts_after_dec15) as avg_reverts_after, avg(reverts_after_dec15/edits_after_dec15) as prop_reverts, avg(registrations) as avg_registrations, avg(registrations/edits_before_dec15) as `registrations/before_edits` from sharedip_all group by 1; +------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ | isarchived | count(*) | avg_edits_before | avg_edits_after | avg_reverts_before | avg_reverts_after | prop_reverts | avg_registrations | registrations/before_edits | +------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ | 0 | 20353 | 92.6129 | 2.0809 | 6.2161 | 0.0921 | 0.03528809 | 0.1003 | 0.00156093 | | 1 | 18738 | 95.2503 | 1.4895 | 6.6335 | 0.0606 | 0.03428909 | 0.1037 | 0.00153709 | +------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ 2 rows in set (0.11 sec)
Standard deviations[edit]
mysql> select isarchived, header_template, count(*), stddev(edits_before_dec15) as stddev_edits_before, stddev(edits_after_dec15) as stddev_edits_after, stddev(reverts_before_dec15) as stddev_reverts_before, stddev(reverts_after_dec15) as stddev_reverts_after, stddev(reverts_after_dec15/edits_after_dec15) as prop_reverts, stddev(registrations) as stddev_registrations, stddev(registrations/edits_before_dec15) as `registrations/before_edits` from sharedip_all group by 1,2 order by 2,1; +------------+----------------------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ | isarchived | header_template | count(*) | stddev_edits_before | stddev_edits_after | stddev_reverts_before | stddev_reverts_after | prop_reverts | stddev_registrations | registrations/before_edits | +------------+----------------------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ | 0 | NULL | 2861 | 269.7137 | 3.0294 | 20.9457 | 0.5406 | 0.09771600 | 0.4648 | 0.00441011 | | 1 | NULL | 15 | 118.3683 | 0.0000 | 7.0503 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 0 | Dynamic_IP | 2 | 34.5000 | 0.0000 | 2.5000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 1 | Dynamic_IP | 1 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 0 | ISP | 1737 | 164.8869 | 22.7671 | 24.8547 | 2.2237 | 0.20504466 | 1.6740 | 0.01972298 | | 1 | ISP | 122 | 421.9723 | 5.9891 | 22.6638 | 0.1270 | 0.01080061 | 0.3785 | 0.00234750 | | 0 | ISP_test | 714 | 68.7376 | 5.1603 | 10.9506 | 0.3853 | 0.13081191 | 0.7178 | 0.04549001 | | 1 | ISP_test | 13825 | 350.3969 | 10.9790 | 48.9770 | 0.9177 | 0.11178442 | 0.5953 | 0.02395303 | | 0 | Mobile_IP | 72 | 255.7428 | 18.2051 | 20.4396 | 0.7004 | 0.11781850 | 2.2146 | 0.06581463 | | 1 | Mobile_IP | 280 | 128.9041 | 4.6320 | 13.1132 | 0.7471 | 0.11483045 | 1.0647 | 0.01904643 | | 0 | Shared_IP | 14187 | 426.0736 | 32.2940 | 24.2545 | 1.3027 | 0.12983218 | 0.7378 | 0.01980737 | | 1 | Shared_IP | 3586 | 508.0136 | 12.7334 | 34.0010 | 0.5977 | 0.11991390 | 0.9126 | 0.00874016 | | 0 | Shared_IP_address_(public) | 171 | 354.2106 | 25.6164 | 28.0610 | 0.5234 | 0.10973073 | 0.6086 | 0.00114526 | | 1 | Shared_IP_address_(public) | 312 | 450.8312 | 17.9919 | 20.8549 | 0.2297 | 0.11409613 | 0.4079 | 0.00543715 | | 0 | Shared_IP_corp | 343 | 728.9018 | 114.8996 | 109.1276 | 21.4600 | 0.07439234 | 1.5772 | 0.02686434 | | 1 | Shared_IP_corp | 385 | 306.0820 | 13.4356 | 19.1582 | 2.1066 | 0.12861666 | 0.8921 | 0.07406561 | | 0 | Shared_IP_corp_test | 1 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.00000000 | 0.0000 | 0.00000000 | | 1 | Shared_IP_corp_test | 6 | 862.6468 | 54.3315 | 63.5070 | 3.2146 | 0.02304115 | 4.2817 | 0.00300302 | | 0 | Shared_IP_edu | 63 | 385.2671 | 4.6696 | 11.9633 | 0.0000 | 0.00000000 | 0.3434 | 0.00119543 | | 1 | Shared_IP_edu | 1 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.00000000 | 0.0000 | 0.00000000 | | 0 | Shared_IP_test | 79 | 81.5503 | 3.0744 | 5.0613 | 0.2487 | 0.13461538 | 0.7068 | 0.02529568 | | 1 | Shared_IP_test | 191 | 150.1033 | 13.7813 | 12.1892 | 0.4499 | 0.03983770 | 1.7424 | 0.07626589 | | 0 | SingNet | 117 | 135.5051 | 4.5307 | 9.1741 | 0.1817 | 0.04351784 | 0.8736 | 0.01222334 | | 1 | SingNet | 14 | 209.4553 | 6.2776 | 16.5383 | 0.0000 | 0.00000000 | 1.1089 | 0.01546801 | | 0 | Whois | 6 | 254.0665 | 88.7025 | 16.1555 | 0.3727 | 0.00195604 | 0.7454 | 0.00134541 | +------------+----------------------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ 25 rows in set (0.08 sec)
mysql> select isarchived, count(*), stddev(edits_before_dec15) as stddev_edits_before, stddev(edits_after_dec15) as stddev_edits_after, stddev(reverts_before_dec15) as stddev_reverts_before, stddev(reverts_after_dec15) as stddev_reverts_after, stddev(reverts_after_dec15/edits_after_dec15) as prop_reverts, stddev(registrations) as stddev_registrations, stddev(registrations/edits_before_dec15) as `registrations/before_edits` from sharedip_all group by 1; +------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ | isarchived | count(*) | stddev_edits_before | stddev_edits_after | stddev_reverts_before | stddev_reverts_after | prop_reverts | stddev_registrations | registrations/before_edits | +------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ | 0 | 20353 | 388.9485 | 31.7524 | 27.2846 | 3.0734 | 0.13572100 | 0.8603 | 0.02042087 | | 1 | 18738 | 388.5991 | 11.5734 | 45.0457 | 0.8939 | 0.11530069 | 0.7112 | 0.02487486 | +------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ 2 rows in set (0.07 sec)
Under 1,000 edits before experiment[edit]
Outcome metrics[edit]
mysql> select isarchived, header_template, count(*), avg(edits_before_dec15) as avg_edits_before, avg(edits_after_dec15) as avg_edits_after, avg(reverts_before_dec15) as avg_reverts_before, avg(reverts_after_dec15) as avg_reverts_after, avg(reverts_after_dec15/edits_after_dec15) as prop_reverts, avg(registrations) as avg_registrations, avg(registrations/edits_before_dec15) as `registrations/before_edits` from sharedip_all where edits_before_dec15 < 1000 group by 1,2 order by 2,1; +------------+----------------------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ | isarchived | header_template | count(*) | avg_edits_before | avg_edits_after | avg_reverts_before | avg_reverts_after | prop_reverts | avg_registrations | registrations/before_edits | +------------+----------------------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ | 0 | NULL | 2818 | 90.0859 | 0.3811 | 6.2331 | 0.0231 | 0.02848806 | 0.0358 | 0.00026844 | | 1 | NULL | 15 | 108.8667 | 0.0000 | 6.6000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 0 | Dynamic_IP | 2 | 35.5000 | 0.0000 | 2.5000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 1 | Dynamic_IP | 1 | 318.0000 | 0.0000 | 17.0000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 0 | ISP | 1728 | 22.3495 | 2.3640 | 2.2436 | 0.1476 | 0.06813415 | 0.1146 | 0.00190953 | | 1 | ISP | 121 | 56.9339 | 1.1653 | 4.0909 | 0.0165 | 0.00426429 | 0.0661 | 0.00035785 | | 0 | ISP_test | 714 | 25.9622 | 1.0980 | 2.5042 | 0.0378 | 0.03222532 | 0.1064 | 0.00397580 | | 1 | ISP_test | 13730 | 45.4748 | 0.8481 | 3.6155 | 0.0399 | 0.03197310 | 0.0551 | 0.00121795 | | 0 | Mobile_IP | 71 | 70.7324 | 4.1268 | 6.4789 | 0.1549 | 0.07039167 | 0.6197 | 0.01438000 | | 1 | Mobile_IP | 279 | 47.5771 | 1.0753 | 5.0717 | 0.0753 | 0.04231515 | 0.2007 | 0.00354727 | | 0 | Shared_IP | 14033 | 66.7926 | 1.4103 | 4.8598 | 0.0487 | 0.03110667 | 0.0857 | 0.00147464 | | 1 | Shared_IP | 3434 | 136.1552 | 2.1118 | 9.9138 | 0.0731 | 0.03590271 | 0.1887 | 0.00137471 | | 0 | Shared_IP_address_(public) | 165 | 104.2182 | 2.9879 | 8.8242 | 0.0606 | 0.02841538 | 0.1152 | 0.00028250 | | 1 | Shared_IP_address_(public) | 306 | 124.0098 | 2.1176 | 8.2255 | 0.0359 | 0.03418333 | 0.0980 | 0.00093072 | | 0 | Shared_IP_corp | 326 | 122.2883 | 6.3436 | 9.1043 | 0.1810 | 0.02051700 | 0.4294 | 0.00651138 | | 1 | Shared_IP_corp | 377 | 145.0584 | 4.9496 | 9.9841 | 0.3475 | 0.04458663 | 0.3846 | 0.00969973 | | 0 | Shared_IP_corp_test | 1 | 336.0000 | 9.0000 | 22.0000 | 0.0000 | 0.00000000 | 0.0000 | 0.00000000 | | 1 | Shared_IP_corp_test | 4 | 112.0000 | 6.0000 | 8.7500 | 0.2500 | 0.02275000 | 0.0000 | 0.00000000 | | 0 | Shared_IP_edu | 61 | 255.4262 | 1.6885 | 15.7049 | 0.0000 | 0.00000000 | 0.0984 | 0.00033934 | | 1 | Shared_IP_edu | 1 | 67.0000 | 16.0000 | 3.0000 | 0.0000 | 0.00000000 | 0.0000 | 0.00000000 | | 0 | Shared_IP_test | 79 | 28.2152 | 0.9367 | 1.5190 | 0.0380 | 0.04807692 | 0.1392 | 0.00540769 | | 1 | Shared_IP_test | 190 | 55.2105 | 2.6263 | 4.6842 | 0.0842 | 0.01895227 | 0.3263 | 0.01097872 | | 0 | SingNet | 117 | 90.5299 | 1.7179 | 5.7607 | 0.0342 | 0.02436875 | 0.2393 | 0.00367872 | | 1 | SingNet | 14 | 180.5714 | 3.1429 | 12.3571 | 0.0000 | 0.00000000 | 0.6429 | 0.00946429 | | 0 | Whois | 6 | 475.8333 | 42.8333 | 34.0000 | 0.1667 | 0.00136667 | 0.3333 | 0.00060000 | +------------+----------------------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+
mysql> select isarchived, count(*), avg(edits_before_dec15) as avg_edits_before, avg(edits_after_dec15) as avg_edits_after, avg(reverts_before_dec15) as avg_reverts_before, avg(reverts_after_dec15) as avg_reverts_after, avg(reverts_after_dec15/edits_after_dec15) as prop_reverts, avg(registrations) as avg_registrations, avg(registrations/edits_before_dec15) as `registrations/before_edits` from sharedip_all where edits_before_dec15 < 1000 group by 1; +------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ | isarchived | count(*) | avg_edits_before | avg_edits_after | avg_reverts_before | avg_reverts_after | prop_reverts | avg_registrations | registrations/before_edits | +------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ | 0 | 20121 | 66.6999 | 1.4528 | 4.8852 | 0.0556 | 0.03459575 | 0.0908 | 0.00157251 | | 1 | 18472 | 66.0571 | 1.2145 | 5.0397 | 0.0531 | 0.03425312 | 0.0928 | 0.00155171 | +------------+----------+------------------+-----------------+--------------------+-------------------+--------------+-------------------+----------------------------+ 2 rows in set (0.12 sec)
Standard deviations[edit]
mysql> select isarchived, header_template, count(*), stddev(edits_before_dec15) as stddev_edits_before, stddev(edits_after_dec15) as stddev_edits_after, stddev(reverts_before_dec15) as stddev_reverts_before, stddev(reverts_after_dec15) as stddev_reverts_after, stddev(reverts_after_dec15/edits_after_dec15) as prop_reverts, stddev(registrations) as stddev_registrations, stddev(registrations/edits_before_dec15) as `registrations/before_edits` from sharedip_all where edits_before_dec15 < 1000 group by 1,2 order by 2,1; +------------+----------------------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ | isarchived | header_template | count(*) | stddev_edits_before | stddev_edits_after | stddev_reverts_before | stddev_reverts_after | prop_reverts | stddev_registrations | registrations/before_edits | +------------+----------------------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ | 0 | NULL | 2818 | 152.6090 | 2.7411 | 14.4977 | 0.5386 | 0.10099689 | 0.4519 | 0.00444695 | | 1 | NULL | 15 | 118.3683 | 0.0000 | 7.0503 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 0 | Dynamic_IP | 2 | 34.5000 | 0.0000 | 2.5000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 1 | Dynamic_IP | 1 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | NULL | 0.0000 | 0.00000000 | | 0 | ISP | 1728 | 72.6049 | 13.6848 | 9.6488 | 1.3780 | 0.20586983 | 1.6780 | 0.01978039 | | 1 | ISP | 121 | 110.1777 | 6.0129 | 7.3451 | 0.1275 | 0.01080061 | 0.3800 | 0.00235696 | | 0 | ISP_test | 714 | 68.7376 | 5.1603 | 10.9506 | 0.3853 | 0.13081191 | 0.7178 | 0.04549001 | | 1 | ISP_test | 13730 | 108.4672 | 9.0387 | 10.7870 | 0.9053 | 0.11263898 | 0.5933 | 0.02403642 | | 0 | Mobile_IP | 71 | 160.1650 | 18.3326 | 14.4328 | 0.7051 | 0.12106499 | 2.2289 | 0.06629533 | | 1 | Mobile_IP | 279 | 109.4995 | 4.6310 | 12.0914 | 0.7464 | 0.11458970 | 1.0655 | 0.01908033 | | 0 | Shared_IP | 14033 | 131.5310 | 11.0971 | 13.7807 | 0.6376 | 0.12701829 | 0.6583 | 0.01991673 | | 1 | Shared_IP | 3434 | 187.8786 | 7.9130 | 19.7234 | 0.4792 | 0.12358312 | 0.8187 | 0.00892767 | | 0 | Shared_IP_address_(public) | 165 | 180.2017 | 10.8789 | 17.8834 | 0.5009 | 0.11524855 | 0.4850 | 0.00111208 | | 1 | Shared_IP_address_(public) | 306 | 167.5558 | 16.0800 | 14.0282 | 0.2185 | 0.11328743 | 0.4085 | 0.00548885 | | 0 | Shared_IP_corp | 326 | 190.7700 | 12.3695 | 15.8173 | 0.6791 | 0.07407735 | 1.5800 | 0.02760490 | | 1 | Shared_IP_corp | 377 | 193.1192 | 12.5010 | 13.9166 | 2.1132 | 0.13079932 | 0.8879 | 0.07483618 | | 0 | Shared_IP_corp_test | 1 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.00000000 | 0.0000 | 0.00000000 | | 1 | Shared_IP_corp_test | 4 | 152.6630 | 9.2736 | 12.9494 | 0.4330 | 0.02272727 | 0.0000 | 0.00000000 | | 0 | Shared_IP_edu | 61 | 136.1730 | 4.4741 | 11.3561 | 0.0000 | 0.00000000 | 0.3485 | 0.00121334 | | 1 | Shared_IP_edu | 1 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | 0.00000000 | 0.0000 | 0.00000000 | | 0 | Shared_IP_test | 79 | 81.5503 | 3.0744 | 5.0613 | 0.2487 | 0.13461538 | 0.7068 | 0.02529568 | | 1 | Shared_IP_test | 190 | 98.6477 | 13.8162 | 10.2811 | 0.4510 | 0.03983770 | 1.7468 | 0.07646428 | | 0 | SingNet | 117 | 135.5051 | 4.5307 | 9.1741 | 0.1817 | 0.04351784 | 0.8736 | 0.01222334 | | 1 | SingNet | 14 | 209.4553 | 6.2776 | 16.5383 | 0.0000 | 0.00000000 | 1.1089 | 0.01546801 | | 0 | Whois | 6 | 254.0665 | 88.7025 | 16.1555 | 0.3727 | 0.00195604 | 0.7454 | 0.00134541 | +------------+----------------------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ <pre style="overflow: auto"> mysql> select isarchived, count(*), stddev(edits_before_dec15) as stddev_edits_before, stddev(edits_after_dec15) as stddev_edits_after, stddev(reverts_before_dec15) as stddev_reverts_before, stddev(reverts_after_dec15) as stddev_reverts_after, stddev(reverts_after_dec15/edits_after_dec15) as prop_reverts, stddev(registrations) as stddev_registrations, stddev(registrations/edits_before_dec15) as `registrations/before_edits` from sharedip_all where edits_before_dec15 < 1000 group by 1; +------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ | isarchived | count(*) | stddev_edits_before | stddev_edits_after | stddev_reverts_before | stddev_reverts_after | prop_reverts | stddev_registrations | registrations/before_edits | +------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+ | 0 | 20121 | 132.8144 | 10.5995 | 13.5925 | 0.7110 | 0.13473533 | 0.8132 | 0.02054249 | | 1 | 18472 | 135.5625 | 9.1105 | 13.2893 | 0.8697 | 0.11715181 | 0.6789 | 0.02505427 | +------------+----------+---------------------+--------------------+-----------------------+----------------------+--------------+----------------------+----------------------------+