/media/sda-magnetic/david/Dok-15-2023-11-27/fernuni-hagen/cs-i-ii/old-cs-2-02/statistik2022-06-10/sql-without-homepage/statistik60.txt

MariaDB [stat_track]> SHOW FIELDS FROM ip_datetime;
MariaDB [stat_track]> @k:=0; SELECT ip, datetime, @k:=@k+1 FROM ip_datetime;
MariaDB [stat_track]> SET @k:=0; SELECT ip, datetime, @k:=@k+1 FROM ip_datetime;
MariaDB [stat_track]> SET @k:=0; SELECT ip, datetime, @k:=@k+1, COUNT(ip) FROM ip_datetime GROUP BY ip;
MariaDB [stat_track]> SET @k:=0; SELECT ip, datetime, @k:=@k+1, COUNT(ip) FROM ip_datetime GROUP BY ip ORDER BY COUNT(ip);
MariaDB [stat_track]> @k:=0; SELECT ip, datetime, @k:=@k+1 FROM ip_datetime;
MariaDB [stat_track]> SET @k:=0; SELECT ip, datetime, @k:=@k+1, COUNT(ip), COUNT(ip)/14889 FROM ip_datetime GROUP BY ip ORDER BY COUNT(ip);