WITH cte1 AS( SELECT COUNT(*) cnt FROM table1 WHERE.... ), cte2 AS( SELECT COUNT(*) cnt FROM table1 WHERE.... ), cte3 AS( SELECT COUNT(*) cnt FROM table 1 WHERE.... ) SELECT cte1.cnt AS cte1, cte2.cnt AS cte2, cte3.cnt AS cte3 FROM cte1, cte2, cte3 SELECT (SELECT COUNT(*) FROM table1 WHERE....) as cte1, (SELECT COUNT(*) FROM table1 WHERE....) as cte2, (SELECT COUNT(*) FROM table1 WHERE....) as cte3
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter