Here is how I m getting my first result :
SELECT PageName, COUNT(DISTINCT Ip) as nb FROM statistique INNER JOIN visite ON statistique.Id = visite.IdPage GROUP BY statistique.Id;
And this is what I'm getting : PageName nb /edsa-PHP/index.php 1 /edsa-PHP/test2.php 1 /PHP/index.php 3 /PHP/test2.php 1
PageName nb
/edsa-PHP/index.php 1
/edsa-PHP/test2.php 1
/PHP/index.php 3
/PHP/test2.php 1
This is how I think I can get the max value of the count :
SELECT MAX(nb) FROM (SELECT PageName, COUNT(DISTINCT Ip) as nb FROM statistique INNER JOIN visite ON statistique.Id = visite.IdPage GROUP BY PageName) AS t;