ExcelR Assignment Solution for BA and Data Analytics. Assignment 1 in SQL, Select, WHERE, DISTINCT

ExcelR Assignment Solution for BA and Data Analytics. Assignment 1 in SQL, SELECT clause with WHERE, AND, DISTINCT, Wild Card (LIKE)

🎯 Title (SEO-friendly)

Master SQL SELECT Queries | WHERE, AND, DISTINCT & LIKE Explained with Examples | SQL for Beginners

Q.1 SELECT clause with WHERE, AND, DISTINCT, Wild Card (LIKE)

a. Fetch the employee number, first name and last name of those employees who are working as Sales Rep reporting to employee with employeenumber 1102 (Refer employee table)


b. Show the unique productline values containing the word cars at the end from the products table.

Expected output:

For Tableau, Excel and PowerBi Videos, watch my playlist and youtube channel link:
   / @vikaseduclass  


📝 Description (SEO Optimized)

Learn how to use the SQL SELECT clause with WHERE, AND, DISTINCT, and Wildcard (LIKE) operators using real-life examples from the employee and products tables.

In this SQL tutorial, we’ll cover:

How to filter data with WHERE

Combine multiple conditions using AND

Remove duplicate records using DISTINCT

Use LIKE with wildcards (%) to find matching text patterns

💡 Example tasks covered:
✅ Fetch employee details reporting to a specific manager (employeeNumber = 1102)
✅ Retrieve product lines ending with the word Cars

Whether you’re learning MySQL, SQL Server, or PostgreSQL, this video will help you understand how SQL queries actually work — step-by-step!

👉 Don’t forget to LIKE, SUBSCRIBE, and SHARE for more SQL, Excel, Power BI, and Tableau tutorials.
📘 Channel: Vikas Educlass

#SQLTutorial #SQLForBeginners #LearnSQL #DatabaseTutorial #SQLPractice #MySQL #SQLServer #SQLQueries #vikaseduclass

VikasEduclass

🔖 Tags (for YouTube SEO)
sql tutorial, sql for beginners, learn sql, sql select query, sql where clause, sql and operator, sql distinct, sql like operator, sql wildcard, mysql tutorial, sql server tutorial, sql practice questions, database tutorial, sql interview questions, sql basics, how to use like in sql, sql filtering data, sql example, sql training, vikas educlass


ExcelR Assignement
SQL ExcelR Assignment Solution
You will get all the solved ExcelR Assignment
Best Youtube Channel is Vikas EduClass
Vikas EduClass
Exceltips and Exceltricks by Vikas Educlass