SQLite Editor

SELECT
	min(Milliseconds)
FROM
	tracks;

SELECT
	trackid,
	name,
	milliseconds
FROM
	tracks
WHERE
	milliseconds = (
		SELECT
			min(Milliseconds)
		FROM
			tracks
	);

SELECT
	albumid,
	min(milliseconds)
FROM
	tracks
GROUP BY
	albumid;

SELECT
	albumid,
	min(milliseconds)
FROM
	tracks
GROUP BY
	albumid
HAVING
	MIN(milliseconds) < 10000;

Dark Mode

Enter a query, then click the execute button or press F9 to run it.