query.sql

-- SELECT subblock, compressionRatio, compressionRatioZ
-- FROM LlcEmeralCherry
-- WHERE compression = 'LZMA2' AND level = 6


SELECT * FROM
(
SELECT ROUND(AVG(compressionRatioZ) - AVG(compressionRatio),5)
FROM ArtemiaZSect
WHERE compression = 'LZMA2' AND level = 6
) a,
(       
SELECT ROUND(AVG(compressionRatioZ) - AVG(compressionRatio),5)
FROM ArtemiaFlash
WHERE compression = 'LZMA2' AND level = 6
) af,
(
SELECT ROUND(AVG(compressionRatioZ) - AVG(compressionRatio),5)
FROM LlcEmeralCherry
WHERE compression = 'LZMA2' AND level = 6
) llc,
(
SELECT ROUND(AVG(compressionRatioZ) - AVG(compressionRatio),5)
FROM Bit16ZStack
WHERE compression = 'LZMA2' AND level = 6
) b16;