Thread:Project:Support desk/SQL queries for stats

Hello! I need to generate a monthly report of the use of wiki in the company I work for. I'm not allowed to install plugins, I can only make queries (selects) via phpmyadmin. Do you have any suggestions? I do not know well the tables, but I thought the following queries:

-- Registered users per month

SELECT left(user_registration,6) as dt_reg, count(*) as qtde FROM user GROUP BY dt_reg

-- Pages created / edited by month

SELECT left(page_touched,6) as dt_addup, count(*) as qtde FROM page GROUP BY dt_addup

I need numbers to show the importance and use of the wiki. Thanks a lot :D