CREATE TABLE "albums" ( `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, `nombre` TEXT );

CREATE TABLE "musica" ( `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, `nombreyruta` TEXT NOT NULL, `anulado` NUMERIC NOT NULL DEFAULT 0, `album` INTEGER, `reproducido` INTEGER NOT NULL DEFAULT 0, `ultimareproduccion` TEXT );

CREATE TABLE "reproduccion" ( `Id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, `idalbum` INTEGER NOT NULL DEFAULT 0, `habilitado` INTEGER NOT NULL DEFAULT 1 )

SELECT musica.id from musica inner join reproduccion on musica.album = reproduccion.idalbum  WHERE musica.reproducido = 0;

SELECT CAST(COUNT(*) * 0.4 AS int) FROM musica

SELECT *
FROM musica m
ORDER BY ultimareproduccion DESC
LIMIT (
  SELECT CAST(COUNT(*) * 0.4 AS int) + 1 FROM musica
)

SELECT c.*
FROM (
  SELECT *
  FROM musica m
  ORDER BY ultimareproduccion DESC
  LIMIT (
    SELECT CAST(COUNT(*) * 0.4 AS int) + 1 FROM musica
  )
) c;