query.sql

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


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