Day 3 of learning Data Science

Day 3

Yesterday I explored about WHERE, comparison operators, etc in SQL.

Today I learned about GROUP BY which is very crucial in SQL. It is used to arrange identical data into groups. GROUP BY clause is placed after and before the WHERE clause ORDER BY clause if used.

SELECT col_name
FROM table_name
WHERE conditions
GROUP BY col_name
ORDER BY col_name;

I also learned about HAVING clause. The difference between WHERE and HAVING clause.

That is all for DAY 3: 23nd May 2023.

Day 2 Link & Day 4 Link

Do not hesitate to connect with me on my Twitter link & LinkedIN

I will update this blog as and when I get the time to, Thanks for reading!