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

[@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?