1 - Mapear quantidade de tipos de enquete pública, privada e modelo
SELECT realm,COUNT(id) AS countrecord FROM mdl_questionnaire_survey GROUP by realm
2 - Mapear quantidade instanciados a partir e modelos públicos / privado
SELECT sid,COUNT(id) AS countrecord FROM mdl_questionnaire GROUP by sid
3 - Mapear quantidade de questões de todas as enquetes
SELECT COUNT(id) AS countrecord FROM mdl_questionnaire_question
4 -Mapear quantidade de questões sem nome (chave de identificação)
SELECT COUNT(id) AS countrecord FROM mdl_questionnaire_question WHERE name IS NULL;
5 - Mapear quantidade de questões por enquete
SELECT survey_id,COUNT(id) AS countrecord FROM mdl_questionnaire_question GROUP BY survey_id
6 - Mapear questões iguais alocados em diferentes enquetes
SELECT content,COUNT(id) AS countrecord FROM mdl_questionnaire_question GROUP BY content HAVING COUNT(id) > 1 ORDER BY COUNT(id) DESC