SQL - Subquerys y un poco de lio

Nombre                              Porcentaje              Asistentes

---------------------------------------------------------------------------------------------

Curso1                                  80%                         214

Curso2                                  15%                          21

Curso3                                   3%                           5

Curso4                                   2%                           3

select C.fullname,C.id as idEsp,(

	select count(*) as Participantes from (

		select count(*) from aulavirtual.mdl_log

			where course = 46

				and action = "view" and module = "course" group by userid

	) as Datos

) as Asistentes from mdl_course C where category = 2;

select C.fullname,C.id as idEsp,(

	select count(*) as Participantes from (

		select count(*) from aulavirtual.mdl_log

			where course = 46  

				and action = "view" and module = "course" group by userid

	) as Datos

) as Asistentes from mdl_course C where category = 2;

select L.course as 'Id de curso',C.fullname as 'Nombre de curso',(

		SELECT count(*) FROM mdl_log

		where course = L.course and module = "course" and userid <> 2

	 ) as 'Numero de accesos'

	 ,(CONCAT(ROUND(

		(((SELECT count(*) FROM mdl_log

			where course = L.course and module = "course" and userid <> 2 ) *100)/(select count(*) from mdl_log

				where course IN (SELECT id FROM aulavirtual.mdl_course where category = C.category)

			and action = "view" and module = "course" and userid <> 2))

	,0),'%')) as Porcentaje

from mdl_course C

inner join mdl_log L ON L.course = C.id

where category = 2

group by course;

select L.course as 'Id de curso',C.fullname as 'Nombre de curso', count(*) as 'Numero de accesos'

	 ,(CONCAT(ROUND(

		(((count(*)) *100)/(select count(*) from mdl_log LO

				where course IN (SELECT id FROM aulavirtual.mdl_course COU where category = C.category

					and COU.id = LO.course)

			and action = "view" and module = "course" and userid <> 2 ) )

	 ,0),'%')) as Porcentaje

from mdl_course C

inner join mdl_log L ON L.course = C.id

where category = 2 and module = "course" and userid <> 2 and action = "view"

group by course;