SQL Week 2 Assignment

Name: Tom Chege Date: 19-04-2026 Database: PostgreSQL

What this covers

This repository is organized into multiple parts, each focusing on a key area of SQL to build a solid foundation in querying and data manipulation.

Part 1: String Operations

Covers techniques for working with and formatting text data.

Part 2: Number Operations

Focuses on handling numeric data, including calculations and transformations.

Part 3: Date and Time

Explores working with dates and timestamps, including extracting and formatting time-based data.

Part 4: Joins

Demonstrates how to combine data from multiple tables using different types of joins.

Part 5: Window Functions

Introduces advanced querying concepts for analyzing data across groups of rows, such as rankings and running totals.

Part 6: Set Operations

Shows how to merge and compare query results using set-based operations.

Article link

[Understanding SQL Window Functions]