---
title: "Muhammad Sufiyan (@InnoSufiyan) | Hashnode"
description: "Experienced MERN stack developer since 2021, blending creativity and technical expertise to build innovative web applications."
url: "https://hashnode.com/@InnoSufiyan"
---

@InnoSufiyan

# Muhammad Sufiyan

@InnoSufiyan · Pakistan · Joined June 2024

Experienced MERN stack developer since 2021, blending creativity and technical expertise to build innovative web applications.

### [📊 PostgreSQL – Filtering Groups with HAVING](https://innosufiyan.hashnode.dev/postgresql-filtering-groups-with-having?utm_source=hashnode&utm_medium=feed)

So far in SQL, we’ve learned these keywords: FROM JOIN WHERE GROUP BY Now we’re introducing a new keyword: 🔥 HAVING At first, HAVING looks very similar to WHERE. But there is one very important diff

4 min read · [innosufiyan.hashnode.dev](https://innosufiyan.hashnode.dev/postgresql-filtering-groups-with-having?utm_source=hashnode&utm_medium=feed)

[Mar 2](https://hashnode.com/posts/postgresql-filtering-groups-with-having/69a4e1a9a7428b958d0669fd)

### [📊 PostgreSQL – Aggregating and Grouping](https://innosufiyan.hashnode.dev/postgresql-aggregating-and-grouping?utm_source=hashnode&utm_medium=feed)

So far in this course, every query we’ve written has done one simple thing: 👉 It fetched rows exactly as they exist in the database. For example: SELECT \* FROM users; This simply returns all rows. B

4 min read · [innosufiyan.hashnode.dev](https://innosufiyan.hashnode.dev/postgresql-aggregating-and-grouping?utm_source=hashnode&utm_medium=feed)

[Mar 2](https://hashnode.com/posts/postgresql-aggregating-and-grouping/69a4de77a7428b958d05c897)

### [Four Kinds of Joins](https://innosufiyan.hashnode.dev/four-kinds-of-joins?utm_source=hashnode&utm_medium=feed)

This is one of those topics that you will probably come back to again and again in the future. Joins are powerful — but they can also be confusing at first. So in this lesson, we are going to understa

4 min read · [innosufiyan.hashnode.dev](https://innosufiyan.hashnode.dev/four-kinds-of-joins?utm_source=hashnode&utm_medium=feed)

[Feb 26](https://hashnode.com/posts/four-kinds-of-joins/69a0bccd0a5a8a5430308cbe)

### [Missing Data in Joins (PostgreSQL + Supabase)](https://innosufiyan.hashnode.dev/missing-data-in-joins-postgresql-supabase?utm_source=hashnode&utm_medium=feed)

In the last lesson, I mentioned two things in a very mysterious way: Sometimes the ordering of FROM and JOIN matters. There are different kinds of joins available in SQL. Now we’re going to unders

4 min read · [innosufiyan.hashnode.dev](https://innosufiyan.hashnode.dev/missing-data-in-joins-postgresql-supabase?utm_source=hashnode&utm_medium=feed)

[Feb 26](https://hashnode.com/posts/missing-data-in-joins-postgresql-supabase/69a0bbbd0a5a8a5430305030)

### [Alternate Forms of JOIN Syntax in SQL](https://innosufiyan.hashnode.dev/alternate-forms-of-join-syntax-in-sql?utm_source=hashnode&utm_medium=feed)

We’ve now written several JOIN queries. Before moving forward, there are some very important things you need to understand about JOIN syntax. These small details will save you from confusion later — e

4 min read · [innosufiyan.hashnode.dev](https://innosufiyan.hashnode.dev/alternate-forms-of-join-syntax-in-sql?utm_source=hashnode&utm_medium=feed)

[Feb 26](https://hashnode.com/posts/alternate-forms-of-join-syntax-in-sql/69a0b5940a5a8a54302ecf8a)
