SELECT FWSales.TitleEnglish, TotalSales, FirstWeekSales,
(FirstWeekSales*100/TotalSales) AS Ratio FROM
(SELECT SoftwareInfo.GameID, TitleEnglish,
MAX(SalesLTD) AS TotalSales FROM SoftwareInfo, SoftwareWeekly
WHERE SoftwareInfo.GameID=SoftwareWeekly.GameID
AND SalesLTD >0 AND TitleEnglish LIKE '%Mario%'
AND TitleEnglish NOT LIKE '%Strikers%' AND TitleEnglish NOT LIKE '%Baseball%'
GROUP BY SoftwareInfo.GameID, TitleEnglish) AS LTDSales,
(SELECT SoftwareInfo.GameID, TitleEnglish, MIN(SalesLTD) AS FirstWeekSales
FROM SoftwareInfo, SoftwareWeekly WHERE SoftwareInfo.GameID=SoftwareWeekly.GameID
AND SalesLTD >0 AND TitleEnglish LIKE '%Super Mario%'
GROUP BY SoftwareInfo.GameID, TitleEnglish) AS FWSales
WHERE FWSales.GameID = LTDSales.GameID ORDER BY Ratio