SELECT * FROM(
SELECT NAME, COUNT('X')VECES FROM
(SELECT ALBUM AS NAME,PLAYDATETIME FROM PLAYBACKS JOIN (DISCS JOIN SINGLES USING(ISVN)) USING(ISVN)
WHERE (PLAYDATETIME>'30/12/18' AND PLAYDATETIME<'01/01/19'))  --SE PUEDE UTILIZAR LA FECHA ACTUAL PERO NO DEVOLVERÍA NINGUN RESULTADO, AQUI DEFINIMOS UN INTERVALO/DIA (31/12/2018)
--WHERE (PLAYDATETIME>SYSDATE-1)
GROUP BY NAME
ORDER BY VECES DESC)
WHERE ROWNUM<11
;