-- ACTIVIDAD 1

-- 1
SELECT Name, Bytes
FROM Track
ORDER BY Bytes ASC
LIMIT 1;

-- 2
SELECT Name, Milliseconds
FROM Track
ORDER BY Milliseconds DESC
LIMIT 1;

-- 3
SELECT COUNT(*) AS Total
FROM Track
WHERE UnitPrice >= 1;

-- 4
SELECT COUNT(*) AS Total
FROM Track
WHERE Composer LIKE '%Queen%';

-- 5
SELECT AVG(Milliseconds) AS MediaDuracion
FROM Track;

-- 6
SELECT AVG(Bytes) AS MediaPeso
FROM Track
WHERE Composer LIKE '%U2%';

-- 7
SELECT COUNT(*) AS Total
FROM Track
WHERE Composer LIKE '%Bill Berry%';

-- 8
SELECT Name, (Bytes / 1024.0 / 1024.0) AS Mb
FROM Track;