Week 1 - Day 1

Topics Covered

• Basic SQL Queries
• WHERE conditions
• LIKE operator
• Aggregate functions (SUM, AVG, COUNT)
• GROUP BY and HAVING
• ORDER BY

Work Done

• Created tables: Employee, Department, Project
• Inserted sample data
• Solved SQL queries from 1 to 35

Tools Used

• DB Fiddle
• GitHub

Learnings

• Understood SQL basics
• Learned filtering using WHERE
• Practiced GROUP BY and aggregation
• Learned sorting using ORDER BY

Next Plan

• Complete remaining queries (36–65)
• Practice JOIN and Nested queries

Progress

• Completed queries 1–35
• Remaining queries will be completed next