Google Big Query SQL Tips, Query Walkthrough with Union and Rank

In this video we are walking through a SQL Problem using Google Big Query.
This problem uses the Union, Order By, As, Group By, Limit and Sum functions in SQL to give us the solution to our problem.

We are looking to find the Top 10 baby names in the US for both male and female. The SQL Tip is to use the union operator to join the results of two queries together.

[Rebellionrider]

I’ve got a SQL trick I’ve been using forever - the UNION clause. It’s perfect for merging data from different sources and ditching duplicates in one go. It’s a real lifesaver when you’re deep into database work! Give it a whirl! 💡👨‍💻

[asyiqmln]

So if i don't use UNION (and WHERE clause), the result will show mix F and M with total 10 rows?