instruction: Command Line Technology Question Closure.
response: SELECT * FROM (SELECT COUNT(CASE WHEN NOT ClosedDate IS NULL THEN 1 END) AS NumPowerShellClosed, COUNT(*) AS NumPowerShell FROM Posts WHERE LOWER(Tags) LIKE '%powershell%') AS PowerShellStats, (SELECT COUNT(CASE WHEN NOT ClosedDate IS NULL THEN 1 END) AS NumBashClosed, COUNT(*) AS NumBash FROM Posts WHERE LOWER(Tags) LIKE '%bash%') AS BashStats