Скачать или смотреть Day 3: SQL LIKE, GROUP BY, HAVING, and Subqueries in PostgreSQL | PG Admin Tutorial

Welcome to Day 3 of the PG Admin & PostgreSQL Tutorial Series!

In this video, we focus on pattern matching, data aggregation, filtering grouped results, and querying inside queries. You'll master key SQL commands like LIKE, GROUP BY, HAVING, and subqueries — all through practical examples using student and staff datasets.

This session is ideal for anyone looking to level up their SQL skills for analytics, backend engineering, or data science!

✅ What You Will Learn in Day 3
Pattern matching with LIKE (e.g., 'L%', '%s', '__a%')

Wildcard usage in LIKE queries

Aggregate functions: COUNT(), MAX(), MIN(), AVG()

Grouping data using GROUP BY

Filtering grouped results with HAVING

Ordering grouped results using ORDER BY

Using LIMIT to fetch top results

IN clause with multiple conditions

Subqueries inside WHERE clause for dynamic filtering

🧰 Tools Used
PostgreSQL 16+

PG Admin 4 (Web GUI)

MacBook (Compatible with Windows/Linux)

📥 Useful Resources

Day 3 Practice SQL: https://github.com/abhishekmishraai/Struct...

🙋 Perfect For
SQL & PostgreSQL Beginners

Data Analysts & Data Scientists

Software Developers

Students learning databases

Backend Engineers



sql like operator
group by in sql
sql having clause
postgresql subqueries
sql pattern matching
sql wildcards
postgresql tutorial
pgadmin tutorial
sql for beginners
sql inner queries
learn sql step by step


#SQL
#PostgreSQL
#PGAdmin
#SQLTutorial
#GroupBy
#LIKEOperator
#Subqueries
#LearnSQL
#DataScience