SQL Basic Lesson 1: 2 Top, Avg, Distinct operator

Welcome to another SQL Server tutorial! 🚀 In this video, we’ll dive deep into some of the most important SQL SELECT functions and keywords that every data analyst, developer, and database enthusiast must know. Whether you’re learning SQL for data analysis, database management, or career advancement, this lesson will give you a clear and practical understanding of how to use these commands effectively. 💡 What You’ll Learn in This Video: ✅ SELECT Statement—How to fetch data from a database ✅ TOP Keyword—How to return only a limited number of rows ✅ DISTINCT Keyword—How to remove duplicate values in your results ✅ COUNT() Function—How to count rows or specific values ✅ AS Keyword—How to rename columns or tables for cleaner output ✅ MAX() and MIN()—How to find the highest and lowest values ✅ AVG() Function—How to calculate the average of numeric columns 🧠 Why This Video Is Important These functions are the foundation of SQL data queries. Understanding them will help you analyse, summarise, and clean your data like a pro—whether you work in Excel, Power BI, or any data analytics role. 📊 Example Topics Covered: SELECT * FROM StaffInfo; SELECT TOP 5 * FROM Sales; SELECT DISTINCT Department StaffWages; SELECT COUNT(*) AS TotalStaffInfo FROM StaffWages; SELECT MAX(Salary) AS HighestSalary, MIN(Salary) AS LowestSalary FROM StaffWages; SELECT AVG(Salary) AS AverageSalary FROM Employees; 🧩 Who This Video Is For: Beginners learning SQL from scratch Data Analysts using SQL Server, Excel, or Power BI Anyone preparing for data or tech interviews 💬 Don’t Forget: 👉 Like 👍 👉 Comment 💬 👉 Subscribe 🔔 for more free SQL tutorials every week! #SQLServer #SQLTutorial #LearnSQL #DataAnalysis #PowerBI #Excel #SQLBeginner #DataAnalystTools