BLOG | DataWithJas

Understanding the “GO” Command in SQL Server

When writing SQL queries in SQL Server, you may have come across the GO command. But why do we use it? What purpose does it serve, and...

#SQL

Sep 30, 20244 min read

1384 - Total Sales Amount by Year [LeetCode]

(To see the full code, go to my github ) Write a solution to report the total sales amount of each item for each year, with corresponding...

#SQL

Sep 29, 20243 min read

Mastering SQL: 12 Essential Tips to Optimize Performance and Secure Your Queries

Writing SQL queries might seem simple, but creating ones that are both efficient and easy to maintain takes practice. By following best...

#SQL

Sep 22, 20245 min read

1127. User Purchase Platform [LeetCode]

(To see the full code, go to my github ) Write an SQL query to find the total number of users and the total amount spent using mobile...

#SQL

Sep 12, 20243 min read

1645 - Hopper Company Queries II [LeetCode]

(To see the full code, go to my github ) Write an SQL query to calculate the percentage of working drivers (working_percentage) for each...

#SQL

Aug 31, 20244 min read

Mastering SQL: Identifying Customers with Consecutive Increasing Transactions

In this article, we will explore how to write an SQL query that identifies customers who have made consecutive transactions with...

#SQL

Aug 30, 20245 min read

2494 — Merge Overlapping Events in the Same Hall [LeetCode]

Question: Write an SQL query to merge all the overlapping events that are held in the same hall. Two events overlap if they have at...

#SQL

Aug 28, 20243 min read

SQL CHALLENGE: Calculating the number of remaining inventories

We want to generate an inventory age report which would show the distribution of remaining inventory across the length of time the...

#SQL

Jul 16, 20243 min read

Maximize Prime Item Inventory [Amazon SQL Interview Question]

(To see the full code, go to my github ) Amazon wants to maximize the storage capacity of its 500,000 square-foot warehouse by...

#SQL

Jul 14, 20243 min read

Solving a Complex SQL Challenge on HackerRank: “15 Days of Learning SQL”

Tackling SQL challenges on platforms like HackerRank can be quite demanding, especially when the problem requires advanced techniques...

#SQL

Jun 10, 20244 min read

Data With Jas

Understanding the “GO” Command in SQL Server

1384 - Total Sales Amount by Year [LeetCode]

Mastering SQL: 12 Essential Tips to Optimize Performance and Secure Your Queries

1127. User Purchase Platform [LeetCode]

1645 - Hopper Company Queries II [LeetCode]

Mastering SQL: Identifying Customers with Consecutive Increasing Transactions

2494 — Merge Overlapping Events in the Same Hall [LeetCode]

SQL CHALLENGE: Calculating the number of remaining inventories

Maximize Prime Item Inventory [Amazon SQL Interview Question]

Solving a Complex SQL Challenge on HackerRank: “15 Days of Learning SQL”