SQL Aggregate Functions with GROUP BY & HAVING CLAUSE| Create Table from Existing Table | Oracle SQL

In this video, you will learn SQL Aggregate Functions with clear explanations and practical examples using Oracle SQL.
This tutorial covers all important concepts like COUNT, SUM, AVG, MIN, MAX, along with GROUP BY clause, HAVING clause, and creating a table from an existing table.
This lecture is very helpful for beginners, college students, and exam preparation, as well as for understanding real-time SQL queries.

📚 Topics Covered in This Video :

1. What are SQL Aggregate Functions
2. COUNT(), SUM(), AVG(), MIN(), MAX()
3. COUNT(*) and COUNT(column)
4. DISTINCT vs ALL in aggregate functions
5. GROUP BY clause – rules & examples
6. GROUP BY with COUNT, SUM, AVG, MIN, MAX
7. WHERE and HAVING clause
8. HAVING clause with real examples
9. CREATE TABLE AS SELECT statement
10. Creating table with data & without data
11. INSERT INTO SELECT with condition

👉 What you’ll learn in this SQL Tutorial :

00:00:00 – Introduction to SQL Concepts

00:00:12 – What are Aggregate Functions in SQL?
00:00:36 – List of commonly used Aggregate Functions in Oracle

00:01:22 – COUNT() Function (COUNT(*) vs COUNT(column))

00:01:45 – SUM() Function with Examples

00:02:08 – AVG() Function

00:02:31 – MIN() and MAX() Functions

00:03:17 – Using DISTINCT with Aggregate Functions

00:04:53 – Introduction to GROUP BY Clause

00:05:16 – Why GROUP BY is Required (Common Errors)

00:06:11 – GROUP BY with COUNT()

00:06:55 – GROUP BY with SUM()

00:07:20 – GROUP BY with AVG()

00:07:45 – GROUP BY with MIN() and MAX()

00:08:58 – Introduction to HAVING Clause

00:10:37 – Practice Exercise

00:12:39 – CREATE TABLE AS SELECT Statement

00:14:17 – INSERT INTO SELECT with Condition (LIKE Operator)

#SQL #OracleSQL #AggregateFunctions #GroupBy #HavingClause
#SQLTutorial #SQLForBeginners #Database #SQLQueries
#LearnSQL #CollegeSQL #SQLNotes