eniola_dd

Protect your inner circle like it is the most valuable thing you own. Because it is. The right people around you can change the entire trajectory of your life. Choose carefully and guard fiercely.

Money & Love Balance Bad to me Everyday Wow

COUNT vs COUNT DISTINCT in BigQuery. COUNT returned 9,999 because it counts repeats; DISTINCT returned 3, the real number of states. GROUP BY then gave orders per state: MI 6,205, TN 2,746, KY 1,048. Also ran it with and without table names in the SELECT. Same result.

Joining an orders table to a warehouses table on warehouse_id in BigQuery. Previewed both tables first, then used aliases and picked only the columns I needed. 9,999 orders matched to their warehouse and state.

LEFT JOIN vs INNER JOIN on NCAA basketball data in BigQuery. Average wins for Division 1 teams in the 1990s, with their mascots. LEFT JOIN returned 320 teams, INNER JOIN 317, because 3 teams have no mascot.

Joining two World Bank education tables in BigQuery. Same INNER JOIN written with full table names, then with aliases, then used to total the secondary school age population by region in 2015.

When people have too much access to you they start to feel entitled.

Her aura in that brown jacket was x100 😮‍💨 It was giving proper boss lady vibes. Love her.

You are suddenly the bad person when you return the same energy 😂😂😂