problema con group by in mysql

[hackerdm]

mi stampa questo

8 - 192.168.0.2 = 00:30:6e:c3:45:6
7 - 192.168.0.0 = 00:1c:b0:78:fc:0c