SQL Archives - THE SATS BLOG

📝 Interactive SQL Worksheet: Learn SQL for Data Analytics

Post author:sats
Post published:May 23, 2025
Post category:DATA ANALYTICS
Post comments:0 Comments

Dataset Overview: Assume we’re working with two tables: 1. Customers customer_idnamecountry1Alice SmithUSA2John LeeCanada3Sara KhanUK 2. Orders order_idcustomer_idorder_dateamount10112024-12-01120.0010222024-12-05150.0010312024-12-09200.00 🧪 PART 1: Basic SELECT Queries Q1. Write a query to get all…

🛠️ The Role of SQL in Data Analytics — and Why You Should Learn It

Post author:sats
Post published:May 23, 2025
Post category:DATA ANALYTICS
Post comments:0 Comments

In the world of data analytics, flashy tools like Python, R, or Tableau often grab the spotlight. But behind almost every data-driven decision lies a foundational language that does the…

Knex query builder null and notNull where conditions

Post author:sats
Post published:February 12, 2024
Post category:Database
Post comments:3 Comments

This tutorial explains how to use null and notNull conditions in where clause using Knex query builder A basic syntax of knex query builder with null and notNull conditions db.select()…