build a sql words 
<pre>
+----+--------------+------+--------+---------+---------------------+-----------
| Id | ip           | uri  | status | browser | time                |refer   ..........
+----+--------------+------+--------+---------+---------------------+-----------
int    varchar       varchar int     varchar   timeStampe            varchar  ..........
-------------------------------------------------------------------------------
</pre>

This is the structure of my table used to save the tomcat logs(pattern is combine) here.

Now I want to do some types of statistics,however I am not good at sql words,so I ask it here.

statistics type is:

1) query which pages are requested most at a same monment. Then I want to show them in a table.
2)query which files are requested most at a same monment. Then I want to show them in a table.
3)query from where (the refer )visitor jump to the site,sort the refers.
build a sql words 
===

<pre>
+----+--------------+------+--------+---------+---------------------+-----------
| Id | ip           | uri  | status | browser | time                |refer   ..........
+----+--------------+------+--------+---------+---------------------+-----------
int    varchar       varchar int     varchar   timeStampe            varchar  ..........
-------------------------------------------------------------------------------
</pre>

This is the structure of my table used to save the tomcat logs(pattern is combine) here.

Now I want to do some types of statistics,however I am not good at sql words,so I ask it here.

statistics type is:

1) query which pages are requested most at a same monment. Then I want to show them in a table.
2)query which files are requested most at a same monment. Then I want to show them in a table.
3)query from where (the refer )visitor jump to the site,sort the refers.