---
title: "Aleks (@aleks-sqlbrief) | Hashnode"
description: "Building SQLBrief: hands-on SQL practice, from your first query to product analytics. Read the latest articles by Aleks on Hashnode."
url: "https://hashnode.com/@aleks-sqlbrief"
---

@aleks-sqlbrief

# Aleks

@aleks-sqlbrief · Joined October 2026

Building SQLBrief: hands-on SQL practice, from your first query to product analytics.

### [Test your SQL date filter with four boundary rows](https://sqlbrief.hashnode.dev/test-your-sql-date-filter-with-four-boundary-rows?utm_source=hashnode&utm_medium=feed)

Catch missing last-day rows with a four-row PostgreSQL check. Compare BETWEEN, 23:59:59 and an exclusive next-month boundary.

3 min read · [sqlbrief.hashnode.dev](https://sqlbrief.hashnode.dev/test-your-sql-date-filter-with-four-boundary-rows?utm_source=hashnode&utm_medium=feed)

[17h ago](https://hashnode.com/posts/test-your-sql-date-filter-with-four-boundary-rows/6af9c21a46bf3e8f65435e9a)

### [The SQL query runs. Why does it return a sword?](https://sqlbrief.hashnode.dev/the-sql-query-runs-why-does-it-return-a-sword?utm_source=hashnode&utm_medium=feed)

A six-row PostgreSQL example shows how valid SQL can return the wrong props. Compare AND and OR, then try the puzzle in an illustrated story.

4 min read · [sqlbrief.hashnode.dev](https://sqlbrief.hashnode.dev/the-sql-query-runs-why-does-it-return-a-sword?utm_source=hashnode&utm_medium=feed)

[Oct 25](https://hashnode.com/posts/the-sql-query-runs-why-does-it-return-a-sword/6addc0b84846183761ea366a)

### [Why a LEFT JOIN reports 100% activation when three users never activated](https://sqlbrief.hashnode.dev/why-a-left-join-reports-100-activation-when-three-users-never-activated?utm_source=hashnode&utm_medium=feed)

Reproduce a PostgreSQL LEFT JOIN mistake, recover the users lost by WHERE, and verify the activation rate with data you can run.

12 min read · [sqlbrief.hashnode.dev](https://sqlbrief.hashnode.dev/why-a-left-join-reports-100-activation-when-three-users-never-activated?utm_source=hashnode&utm_medium=feed)

[Oct 18](https://hashnode.com/posts/why-a-left-join-reports-100-activation-when-three-users-never-activated/6ad4d919e04956dc073b96a3)
