I am in postgresql. I am doing a funnel in sql and started by doing it for the first two categories and worked fine but for the third one i got this error:
ERROR: syntax error at or near "SELECT" Position: 16570
all of the queries i have added work fine.
SELECT 'Total # of orders' AS "Orders",
Count() AS Customers
FROM cat_one
UNION
SELECT '# of orders using elyn' AS "Orders",
Count() AS Customers
FROM cat_two
SELECT '# of orders using ' AS "Orders",
Count(*) AS Customers
FROM cat_three
ORDER BY customers DESC