Angel Avendaño5,013 Points
Count the total of rows in the result query when UNION is present
In the first exercice "Find All Books" , when I run:
SELECT * FROM books_north UNION ALL SELECT * FROM books_south;
Where do I have to put 'COUNT' in the query to get the total rows in it?
To get the count of a union operation I would put the count outside of the query like so:
select count(*) from (select title from books_north union select title from books_south);