Gee_kay ☆

Building a career in data analysis • Pharmacy Student • Stoic • Learning finance

[Gee_kay ☆ @web3_chemist0]

I'm starting a career in Data analytics.

Algorithm connect me with:

- Data scientist
- Data Analysis
- Data Engineers

And other related data course.

[Gee_kay ☆ @web3_chemist0]

@22385_ @vheeorji22 @Faruqmayorwa @ezekiel_aleke @officialladi_T In the code above.

SQL selects two columns and then for the over function, it finds the minimum date in the order_date column and places it in a new column called earlier order date.

[Gee_kay ☆ @web3_chemist0]

@22385_ @vheeorji22 @Faruqmayorwa @ezekiel_aleke @officialladi_T I have not learnt the full scope of how to use over function but here is what I know:

It creates like a window for rows and then perform calculations inside those rows, it is familiar to using agg functions like COUNT with GROUP BY.

[Gee_kay ☆ @web3_chemist0]

Day 5 of learning SQL on Kaggle.

I was supposed to do some exercises but I was occupied today. 😪

I only had time to read the functions.
I got familiar with how the OVER AND PARTITION BY function works.

I will be doing some exercises tomorrow.

[Gee_kay ☆ @web3_chemist0]

Day 4 of learning SQL on Kaggle.

I was asked to use the UNION function to join two columns together, I also filtered within a specific time frame while returning only distinct values from the columns asked.

[Gee_kay ☆ @web3_chemist0]

Day 4 of learning SQL on Kaggle.

I was asked to use the UNION function to join two columns together, I also filtered within a specific time frame while returning only distinct values from the columns asked.

[Gee_kay ☆ @web3_chemist0]

Day 3 of learning SQL on Kaggle.

Today's exercise asked me to include a specific time frame for the users table, include the first time the user posted question in the question table and answers in the answers table. while joining the three tables together by their identical ID.

[Gee_kay ☆ @web3_chemist0]

@22385_ @vheeorji22 @Faruqmayorwa @Femiforge @ezekiel_aleke Ohh, nice.
Kind of like an alternative for COUNT function and group by

[Gee_kay ☆ @web3_chemist0]

Good morning my fellow data analyst. 😆

I completed the into to Sql course on kaggle.
I have already started the Advanced SQL course.

More updates on that soon.

[Gee_kay ☆ @web3_chemist0]

@wisdomabang1 Thanks bro.
Mutuals?

[Gee_kay ☆ @web3_chemist0]

Day 3 of learning SQL on Kaggle.

Today's exercise asked me to include a specific time frame for the users table, include the first time the user posted question in the question table and answers in the answers table. while joining the three tables together by their identical ID.

[Gee_kay ☆ @web3_chemist0]

Day 2 of learning SQL on Kaggle.

I used the JOIN function to combine two tables together using the column "Id" available in both tables.

I also filtered out words including biqquery using the wildcard operator "%"

I also used aliasing to remame the tables used.

[Gee_kay ☆ @web3_chemist0]

@datawithsarah1 Thank you!
Mutuals?

[Gee_kay ☆ @web3_chemist0]

I have fully completed the Data Analytics course on coursera. 😆

I'm officially a Data Analyst 🥳

Time to build a portfolio!

[Gee_kay ☆ @web3_chemist0]

@ud_shalom Ohh, that makes sense.
Mutuals?

[Gee_kay ☆ @web3_chemist0]

@22385_ @vheeorji22 @Faruqmayorwa @Femiforge @ezekiel_aleke That's nice.
Mutuals?

[Gee_kay ☆ @web3_chemist0]

@22385_ @vheeorji22 @Faruqmayorwa @Femiforge @ezekiel_aleke Where are you learning from then?

[Gee_kay ☆ @web3_chemist0]

Day 2 of learning SQL on Kaggle.

I used the JOIN function to combine two tables together using the column "Id" available in both tables.

I also filtered out words including biqquery using the wildcard operator "%"

I also used aliasing to remame the tables used.

[Gee_kay ☆ @web3_chemist0]

Day 1 of learning SQL on KAGGLE.

I learnt about CTE(Common table expression) using the WITH....AS clause.

This function is helpful in creating and querying a temporary table that helps to understand the full table.

[Gee_kay ☆ @web3_chemist0]

@YashKumarP93601 I would love to also.
You are in an interesting field.
I have given you a follow.

[Gee_kay ☆ @web3_chemist0]

Day 1 of learning SQL on KAGGLE.

I learnt about CTE(Common table expression) using the WITH....AS clause.

This function is helpful in creating and querying a temporary table that helps to understand the full table.

[Gee_kay ☆ @web3_chemist0]

@comfortfajugbag You should also build your skills on kaggle.
Preferably SQL and do a lot of exercises

[Gee_kay ☆ @web3_chemist0]

What's the difference ?

- Count(*)
- Count(1)
- Count(ID)