How I can get count results with cross join?
Example cross join:
SELECT t1.firstname, t2.lastname FROM table1 t1 CROSS JOIN table1 t2
You could do this:
or this format which will allow you to copy and paste any query without rewriting it and use it as a subquery:
The same way you get a count with any other aggregate---all the columns that participate in the query need to be accounted for either in an aggregate or a