---
title: "Anish Panda (@anISH601) | Hashnode"
description: "#include<anISH>. Read the latest articles by Anish Panda on Hashnode."
url: "https://hashnode.com/@anISH601"
---

@anISH601

# Anish Panda

@anISH601 · Joined February 2024

#include<anISH>

### [Advanced SQL Practice - Q2 \[Med\] - Tesla](https://anish601.hashnode.dev/advanced-sql-practice-q2-med-tesla?utm_source=hashnode&utm_medium=feed)

You are given a table of product launches by company by year. Write a query to count the net difference between the number of products companies launched in 2020 with the number of products companies launched in the previous year. Output the name of ...

1 min read · [anish601.hashnode.dev](https://anish601.hashnode.dev/advanced-sql-practice-q2-med-tesla?utm_source=hashnode&utm_medium=feed)

[Feb 2](https://hashnode.com/posts/advanced-sql-practice-q2-med-tesla/69802be3cb4cd5215fa54e1f)

### [Advanced SQL Practice - Q1 \[Med\]](https://anish601.hashnode.dev/advanced-sql-practice-q1-med?utm_source=hashnode&utm_medium=feed)

You are analyzing a social network dataset at Google. Your task is to find mutual friends between two users, Karl and Hans. There is only one user named Karl and one named Hans in the dataset. The output should contain 'user\_id' and 'user\_name' col...

1 min read · [anish601.hashnode.dev](https://anish601.hashnode.dev/advanced-sql-practice-q1-med?utm_source=hashnode&utm_medium=feed)

[Jan 30](https://hashnode.com/posts/advanced-sql-practice-q1-med/697c15877e9cdde4ff086b70)

### [Common Data Engineering Patterns](https://anish601.hashnode.dev/common-data-engineering-patterns?utm_source=hashnode&utm_medium=feed)

data engineering design patterns

4 min read · [anish601.hashnode.dev](https://anish601.hashnode.dev/common-data-engineering-patterns?utm_source=hashnode&utm_medium=feed)

[Jan 29](https://hashnode.com/posts/common-data-engineering-patterns/697b1180a36c927e999e910f)

### [Common Cloud Dataflow Patterns (Python Implementation)](https://anish601.hashnode.dev/common-cloud-dataflow-patterns-python-implementation?utm_source=hashnode&utm_medium=feed)

1\. GroupBy Using Multiple Data Properties Pattern Description: When data elements need to be grouped by more than one property (e.g., location and device type), you cannot simply pass multiple keys to a standard group transform. Solution: Create a co...

4 min read · [anish601.hashnode.dev](https://anish601.hashnode.dev/common-cloud-dataflow-patterns-python-implementation?utm_source=hashnode&utm_medium=feed)

[Jan 26](https://hashnode.com/posts/common-cloud-dataflow-patterns-python-implementation/69776b58f936a9db0af0b7c7)
