TGViewer
Channel Public Channel
Data Science & Machine Learning

Data Science & Machine Learning

@datasciencefun

Join this channel to learn data science, artificial intelligence and machine learning with funny quizzes, interesting projects and amazing resources for free

For collaborations: @love_data
Subscribers
77.7K
Photos
905
Videos
1
Links
825
Recent Posts 20 shown
Post #4649 2.05K
Data Visualisation tips for beginners
  • โค 12
  • ๐Ÿ‘ 2
Post #4648 2.62K
๐—™๐—ฅ๐—˜๐—˜ ๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€ ๐—ง๐—ผ ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป ๐—”๐—œ ๐—ถ๐—ป ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ๐Ÿš€
โ€‹
Explore 6 free resources covering AI fundamentals, tools, deep learning, research and real-world applications.

โœ… 100% Free Learning
โœ… Beginner-Friendly
โœ… AI โ€ข ML โ€ข Deep Learning
โœ… Real-World Applications

๐Ÿ”— ๐—˜๐˜…๐—ฝ๐—น๐—ผ๐—ฟ๐—ฒ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐Ÿ‘‡

https://pdlink.in/4AFHq5R

๐Ÿ“ข Share this valuable opportunity with your friends and classmates!
  • โค 1
  • ๐Ÿ‘ 1
Post #4647 2.63K
๐Ÿ”น Real-World Data Science Example

Suppose you are analyzing sales data. You want to identify the highest-value transactions.

SELECT customer_id, product_id, quantity, price,
quantity * price AS transaction_value
FROM sales
ORDER BY transaction_value DESC;


This can help with:

โ€ข Finding high-value transactions

โ€ข Identifying important customers

โ€ข Investigating unusually large purchases

โ€ข Preparing data for further analysis

๐Ÿ”น Common Mistakes

Mistake 1 โ€” Forgetting DESC

If you want the highest salary first: ORDER BY salary DESC; Not ORDER BY salary;

Mistake 2 โ€” Wrong column

Make sure the column used for sorting actually represents what you want to analyze.

Mistake 3 โ€” Incorrect multiple-column ordering

ORDER BY department, salary DESC; does NOT mean both columns are descending. It means: department โ†’ ASC, salary โ†’ DESC

If you want both descending: ORDER BY department DESC, salary DESC;

Mistake 4 โ€” Confusing WHERE and ORDER BY

WHERE filters rows. ORDER BY sorts rows. They perform different jobs.

๐Ÿ”น Interview Questions

1. What is ORDER BY?

ORDER BY sorts query results based on one or more columns.

2. What is the default sorting order?

Ascending order (ASC) is generally the default.

3. How do you find the highest salary?

SELECT * FROM employees ORDER BY salary DESC;


4. Can you sort using multiple columns?

Yes. ORDER BY department ASC, salary DESC;

5. What is the difference between ASC and DESC?

ASC sorts from low to high or Aโ€“Z. DESC sorts from high to low or Zโ€“A.

๐ŸŽฏ Practice Questions

1. Write a query to display all products from the cheapest to the most expensive.

2. Write a query to display employees from the highest salary to the lowest salary.

3. Write a query to display customers alphabetically by name.

4. Write a query to sort sales by date, showing the newest sales first.

5. Write a query to sort employees by department alphabetically and salary from highest to lowest within each department.

๐ŸŽฏ Key Takeaways

โ€ข ORDER BY sorts query results

โ€ข ASC means ascending

โ€ข DESC means descending

โ€ข Ascending is generally the default

โ€ข You can sort numbers, text and dates

โ€ข You can sort using multiple columns

โ€ข WHERE filters data; ORDER BY sorts data

โ€ข ORDER BY is especially useful when analyzing rankings and top/bottom records

๐Ÿ‘‰ Double Tap โค๏ธ For More
  • โค 4
  • ๐Ÿ‘ 1
Post #4646 1.64K
๐Ÿš€ Data Science Roadmap 2026

๐Ÿ“ Phase 3: SQL for Data Science

๐Ÿ“– Topic 3 โ€” ORDER BY

ORDER BY is used to sort the rows returned by a SQL query. It helps you arrange data in a meaningful order, such as:

โ€ข Highest salary to lowest salary

โ€ข Lowest price to highest price

โ€ข Newest date to oldest date

โ€ข Aโ€“Z or Zโ€“A

โ€ข Highest sales to lowest sales

๐Ÿ”น Basic Syntax

SELECT column1, column2
FROM table_name
ORDER BY column_name;


By default, SQL sorts in ascending order.

SELECT *
FROM employees
ORDER BY salary;


This generally returns employees from the lowest salary to the highest salary.

๐Ÿ”น ASC โ€” Ascending Order

ASC means ascending.

SELECT *
FROM employees
ORDER BY salary ASC;


For numbers: 10000, 25000, 40000, 75000, 100000

For text: Amazon, Apple, Google, Microsoft

For dates: 2024-01-01, 2024-05-15, 2024-12-20, 2025-03-10

ASC is usually the default, so ORDER BY salary; is equivalent to ORDER BY salary ASC;

๐Ÿ”น DESC โ€” Descending Order

DESC means descending.

SELECT *
FROM employees
ORDER BY salary DESC;


Example: 100000, 75000, 40000, 25000, 10000

This is especially useful when you want to find:

โ€ข Highest-paid employees

โ€ข Top-selling products

โ€ข Most expensive products

โ€ข Most recent transactions

โ€ข Highest-performing regions

๐Ÿ”น Sorting Text

You can sort text columns alphabetically.

SELECT employee_name, department
FROM employees
ORDER BY employee_name ASC;


SELECT employee_name, department
FROM employees
ORDER BY employee_name DESC;


๐Ÿ”น Sorting Dates

To find the most recent transactions:

SELECT transaction_id, transaction_date, amount
FROM transactions
ORDER BY transaction_date DESC;


To see transactions from oldest to newest:

SELECT transaction_id, transaction_date, amount
FROM transactions
ORDER BY transaction_date ASC;


๐Ÿ”น Sorting by Multiple Columns

This is very important. Suppose you want to sort employees:

1. By department

2. Within each department, by salary from highest to lowest

SELECT employee_name, department, salary
FROM employees
ORDER BY department ASC, salary DESC;


SQL first sorts by department. When multiple rows have the same department, it then uses salary to determine their order.

Example:

Finance 90000

Finance 70000

Finance 50000

HR 85000

HR 60000

IT 120000

IT 95000

๐Ÿ”น ORDER BY with Calculations

You can also sort using an expression.

SELECT product_name, quantity, price,
quantity * price AS total_value
FROM products
ORDER BY quantity * price DESC;


You can also use the alias in many SQL databases:

SELECT product_name,
quantity * price AS total_value
FROM products
ORDER BY total_value DESC;


๐Ÿ”น ORDER BY with DISTINCT

SELECT DISTINCT department
FROM employees
ORDER BY department ASC;


This returns each department once and sorts them alphabetically.

๐Ÿ”น ORDER BY and NULL Values

NULL represents a missing or unknown value. The position of NULL values when using ORDER BY can vary between SQL databases.

Some databases also support explicit control such as:

ORDER BY salary ASC NULLS LAST;


or

ORDER BY salary DESC NULLS FIRST;


Always check the syntax supported by your SQL database.

๐Ÿ”น ORDER BY with WHERE

WHERE filters the rows first, and ORDER BY sorts the resulting rows.

SELECT employee_name, salary
FROM employees
WHERE department = 'IT'
ORDER BY salary DESC;
  • โค 4
Post #4645 1.24K
๐ŸŽ“ ๐—›๐—”๐—ฅ๐—ฉ๐—”๐—ฅ๐—— ๐—จ๐—ก๐—œ๐—ฉ๐—˜๐—ฅ๐—ฆ๐—œ๐—ง๐—ฌ ๐—™๐—ฅ๐—˜๐—˜ ๐—ข๐—ก๐—Ÿ๐—œ๐—ก๐—˜ ๐—–๐—ข๐—จ๐—ฅ๐—ฆ๐—˜๐—ฆ ๐Ÿ˜

Dreaming of learning from one of the worldโ€™s most prestigious universities? Explore Harvardโ€™s online courses and build valuable, career-ready skills from home!

๐Ÿ’ก Beginner-friendly options
โฐ Learn at your own pace
๐ŸŒ Accessible online worldwide
๐ŸŽฏ Ideal for students, freshers and working professionals

๐Ÿ”— ๐—˜๐˜…๐—ฝ๐—น๐—ผ๐—ฟ๐—ฒ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐Ÿ‘‡

https://pdlink.in/4xPUdzU

๐Ÿ“ข Share this valuable opportunity with your friends and classmates!
  • โค 2
Post #4644 1.88K
Complete Data Analytics Mastery: From Basics to Advanced ๐Ÿš€

Begin your Data Analytics journey by mastering the fundamentals:
- Understanding Data Types and Formats
- Basics of Exploratory Data Analysis (EDA)
- Introduction to Data Cleaning Techniques
- Statistical Foundations for Data Analytics
- Data Visualization Essentials

Grasp these essentials in just a week to build a solid foundation in data analytics.

Once you're comfortable, dive into intermediate topics:
- Advanced Data Visualization (using tools like Tableau)
- Hypothesis Testing and A/B Testing
- Regression Analysis
- Time Series Analysis for Analytics
- SQL for Data Analytics

Take another week to solidify these skills and enhance your ability to draw meaningful insights from data.

Ready for the advanced level? Explore cutting-edge concepts:
- Machine Learning for Data Analytics
- Predictive Analytics
- Big Data Analytics (Hadoop, Spark)
- Advanced Statistical Methods (Multivariate Analysis)
- Data Ethics and Privacy in Analytics

These advanced concepts can be mastered in a couple of weeks with focused study and practice.

Remember, mastery comes with hands-on experience:
- Work on a simple data analytics project
- Tackle an intermediate-level analysis task
- Challenge yourself with an advanced analytics project involving real-world data sets

Consistent practice and application of analytics techniques are the keys to becoming a data analytics pro.

Best platforms to learn:
- SQL courses with Certificate
- Freecodecamp Python Course
- 365DataScience
- Data Analyst Interview Questions
- Free SQL Resources

Share your progress and insights with others in the data analytics community. Enjoy the fascinating journey into the realm of data analytics! ๐Ÿ‘ฉโ€๐Ÿ’ป๐Ÿ‘จโ€๐Ÿ’ป

Join @free4unow_backup for more free resources.

Like this post if it helps ๐Ÿ˜„โค๏ธ

ENJOY LEARNING ๐Ÿ‘๐Ÿ‘
  • โค 4
  • ๐Ÿ‘ 1
Post #4643 1.76K
๐—Ÿ๐—ฒ๐˜ƒ๐—ฒ๐—น ๐—จ๐—ฝ ๐—ฌ๐—ผ๐˜‚๐—ฟ ๐—ฆ๐—ธ๐—ถ๐—น๐—น๐˜€ ๐˜„๐—ถ๐˜๐—ต ๐—ง๐—ต๐—ฒ๐˜€๐—ฒ ๐—š๐—ฎ๐—บ๐—ฒ-๐—–๐—ต๐—ฎ๐—ป๐—ด๐—ถ๐—ป๐—ด ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€!
โ€‹
Looking to learn practical, in-demand skills? These courses cover Generative AI, Cybersecurity, AI tools and Digital Marketing.

๐Ÿ’ซ Learn at your own pace
โšกBuild career-relevant skills
๐Ÿ”ฅPractical learning opportunities

๐—˜๐˜…๐—ฝ๐—น๐—ผ๐—ฟ๐—ฒ ๐˜๐—ต๐—ฒ ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ :-

https://pdlink.in/4z3vOYU

Save this post and share with your friends
  • โค 4
Post #4642 1.94K
  • โค 1
Post #4641 1.81K
  • โค 1
Post #4640 1.52K
  • โค 2
Post #4639 1.56K
  • โค 2
Post #4638 1.52K
  • โค 2
Post #4637 1.62K
๐Ÿš€ ๐—š๐—ผ๐—ผ๐—ด๐—น๐—ฒ ๐—ฃ๐—ฟ๐—ผ๐—ณ๐—ฒ๐˜€๐˜€๐—ถ๐—ผ๐—ป๐—ฎ๐—น ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ฒ๐˜€ ๐—ถ๐—ป ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜๐—ถ๐—ฐ๐˜€ & ๐—”๐—œ! ๐Ÿ“Š

Explore these 4 Google learning programs and develop practical, career-relevant skills.

๐ŸŽ“ Explore the programs:
1๏ธโƒฃ Google Data Analytics Professional Certificate
2๏ธโƒฃ Google Business Intelligence Professional Certificate
3๏ธโƒฃ Google AI Essentials
4๏ธโƒฃ Google Advanced Data Analytics Professional Certificate

๐Ÿ”— ๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—ณ๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜ ๐Ÿ‘‡:-

https://pdlink.in/4htgIEW

๐Ÿ“Œ Save this post and share it with someone interested in Data Analytics or AI!
  • โค 6
Post #4636 2.42K
Important Excel, Tableau, Statistics, SQL related Questions with answers

1. What are the common problems that data analysts encounter during analysis?

The common problems steps involved in any analytics project are:

Handling duplicate data
Collecting the meaningful right data at the right time
Handling data purging and storage problems
Making data secure and dealing with compliance issues

2. Explain the Type I and Type II errors in Statistics?

In Hypothesis testing, a Type I error occurs when the null hypothesis is rejected even if it is true. It is also known as a false positive.

A Type II error occurs when the null hypothesis is not rejected, even if it is false. It is also known as a false negative.

3. How do you make a dropdown list in MS Excel?

First, click on the Data tab that is present in the ribbon.
Under the Data Tools group, select Data Validation.
Then navigate to Settings > Allow > List.
Select the source you want to provide as a list array.

4. How do you subset or filter data in SQL?

To subset or filter data in SQL, we use WHERE and HAVING clauses which give us an option of including only the data matching certain conditions.

5. What is a Gantt Chart in Tableau?

A Gantt chart in Tableau depicts the progress of value over the period, i.e., it shows the duration of events. It consists of bars along with the time axis. The Gantt chart is mostly used as a project management tool where each bar is a measure of a task in the project
  • โค 5
Post #4635 1.79K
๐Ÿš€ ๐๐ž๐œ๐จ๐ฆ๐ž ๐š๐ง ๐€๐ˆ ๐„๐ง๐ ๐ข๐ง๐ž๐ž๐ซ ๐ข๐ง ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ”

๐ŸŽฏ Choose Your Learning Track:

๐Ÿ’ป Java Full Stack + AI Engineering
๐ŸŒ MERN Full Stack + AI Engineering

Placement Highlights: โ‚น41 LPA highest package | โ‚น7.4 LPA average package | 2,000+ students placed | 500+ hiring partners

๐Ÿ”— ๐—•๐—ผ๐—ผ๐—ธ ๐—™๐—ฅ๐—˜๐—˜ ๐——๐—ฒ๐—บ๐—ผ ๐—–๐—น๐—ฎ๐˜€๐˜€ :- https://pdlink.in/4fWJVID

โšก AI is creating new career opportunitiesโ€”start building the skills companies need in 2026!
  • โค 3
Post #4634 2.1K
โŒ Mistake 2: Forgetting quotes around text

Incorrect:

WHERE city = Pune;


Correct:

WHERE city = 'Pune';


โŒ Mistake 3: Using AND when you mean OR

Incorrect if you want either city:

WHERE city = 'Pune'
AND city = 'Mumbai';


A single city value cannot normally be both at the same time.

Correct:

WHERE city = 'Pune'
OR city = 'Mumbai';


Or:

WHERE city IN ('Pune', 'Mumbai');


โŒ Mistake 4: Forgetting parentheses

For complex conditions, use parentheses:

WHERE
(city = 'Pune' OR city = 'Mumbai')
AND age > 30;


โŒ Mistake 5: Assuming BETWEEN excludes the boundaries

BETWEEN is generally inclusive.

๐Ÿ”น 34. Interview Questions

๐Ÿ’ก What is the purpose of WHERE?

WHERE filters rows based on a condition.

๐Ÿ’ก What is the difference between WHERE and SELECT?

SELECT โ†’ Determines what columns/expressions appear in the result.

WHERE โ†’ Determines which rows are included.

๐Ÿ’ก How do you check for NULL?

Use:

IS NULL

or:

IS NOT NULL

๐Ÿ’ก What is the difference between IN and OR?

IN provides a concise way to test whether a value matches any value in a list.

๐Ÿ’ก Is BETWEEN inclusive?

Yes, BETWEEN generally includes both boundary values.

๐ŸŽฏ Practice Questions

Q1. Write a query to retrieve employees whose salary is greater than 50,000.

Q2. Write a query to retrieve customers from Pune or Mumbai.

Q3. Write a query to retrieve products priced between 1,000 and 5,000.

Q4. Write a query to retrieve customers whose phone number is missing.

Q5. Write a query to retrieve orders where the status is Success and the amount is greater than 10,000.

๐ŸŽฏ Key Takeaways

โœ… WHERE is used to filter rows.

โœ… = checks equality.

โœ… <> and != can be used for not equal.

โœ… AND requires all specified conditions to be true.

โœ… OR requires at least one condition to be true.

โœ… IN is useful for matching multiple values.

โœ… BETWEEN is useful for ranges and is generally inclusive.

โœ… LIKE is used for pattern matching.

โœ… % represents a sequence of characters.

โœ… _ represents one character.

โœ… Use IS NULL and IS NOT NULL for NULL values.

โœ… Parentheses make complex AND/OR logic clearer and safer.

๐Ÿงญ Double Tap โค๏ธ For More
  • โค 6
Post #4633 1.24K
But IN makes this much cleaner:

SELECT *
FROM customers
WHERE city IN ('Pune', 'Mumbai', 'Delhi');


IN checks whether a value belongs to a specified list.

๐Ÿ”น 23. NOT IN

You can also exclude multiple values.

SELECT *
FROM customers
WHERE city NOT IN ('Pune', 'Mumbai');


This returns customers whose city isn't Pune or Mumbai.

๐Ÿ”น 24. LIKE

LIKE is used for pattern matching.

Suppose we want names beginning with A.

SELECT *
FROM customers
WHERE name LIKE 'A%';


Here:

% โ†’ Any sequence of characters

So this could match:

Alice

Amit

Ananya

๐Ÿ”น 25. LIKE with %

Example:

SELECT *
FROM customers
WHERE name LIKE '%an%';


This searches for names containing the sequence an.

The exact behavior can depend on database collation and case-sensitivity settings.

๐Ÿ”น 26. LIKE with _

The underscore _ generally represents exactly one character.

Example:

SELECT *
FROM products
WHERE product_code LIKE 'A_1';


This could match:

A11

AB1

AX1

But not:

A123

A1

because _ represents one character.

๐Ÿ”น 27. NULL Values

One of the most important concepts in SQL filtering is NULL.

NULL generally means:



Missing, unknown, or unavailable value.



It does not mean:

Zero

Empty string

False

For example:

customer_id name phone

101 Alice 9999999999

102 Bob NULL

Bob's phone number is missing or unknown.

๐Ÿ”น 28. Checking for NULL

You should not normally write:

WHERE phone = NULL


Instead, use:

SELECT *
FROM customers
WHERE phone IS NULL;


To find records where the value exists:

SELECT *
FROM customers
WHERE phone IS NOT NULL;


This is extremely important in Data Analytics.

๐Ÿ”น 29. WHERE and NULL Logic

Suppose:

WHERE salary > 50000


What happens when salary is NULL?

The condition isn't considered true.

The row won't be returned.

SQL uses three-valued logic involving:

TRUE

FALSE

UNKNOWN

This is one reason NULL handling requires special attention.

๐Ÿ”น 30. WHERE with SELECT

WHERE works together with SELECT.

Example:

SELECT
customer_id,
name,
city
FROM customers
WHERE city = 'Pune';


The query:

1.

Retrieves selected columns

2.

From the customers table

3.

Keeps only rows satisfying the condition

๐Ÿ”น 31. WHERE in Real-World Data Science

Imagine a transaction database containing millions of records.

A Data Scientist needs:



Successful transactions above โ‚น10,000 from January 2026 onward.



A query might look like:

SELECT
transaction_id,
customer_id,
transaction_date,
amount
FROM transactions
WHERE status = 'Success'
AND amount > 10000
AND transaction_date >= '2026-01-01';


This is much more efficient for analysis than extracting the entire table and filtering everything later in Python.

๐Ÿ”น 32. WHERE Before Python

A common Data Science workflow is:

Database โ†’ SQL โ†’ Filter/Transform โ†’ Python โ†’ Analysis โ†’ Model

For example:

SELECT
customer_id,
amount,
transaction_date
FROM transactions
WHERE status = 'Success';


Then load the result into Pandas:

import pandas as pd

df = pd.read_sql(query, connection)


SQL handles the database-side filtering, while Python can then handle deeper analysis.

๐Ÿ”น 33. Common Mistakes

โŒ Mistake 1: Using = with NULL

Incorrect:

WHERE phone = NULL;


Correct:

WHERE phone IS NULL;
  • โค 2
Post #4632 814
SELECT *
FROM customers
WHERE city = 'Pune'
OR city = 'Mumbai';


This returns customers from either Pune or Mumbai.

๐Ÿ”น 14. AND vs OR

Consider:

WHERE age > 30
AND city = 'Pune'


A customer must satisfy both conditions.

But:

WHERE age > 30
OR city = 'Pune'


A customer only needs to satisfy one or both conditions.

This difference is extremely important.

๐Ÿ”น 15. NOT

NOT reverses a condition.

Example:

SELECT *
FROM customers
WHERE NOT city = 'Pune';


This returns customers who aren't from Pune.

You can also commonly write:

SELECT *
FROM customers
WHERE city <> 'Pune';


๐Ÿ”น 16. Combining AND and OR

You can combine multiple logical operators.

Example:

SELECT *
FROM employees
WHERE department = 'Finance'
AND salary > 60000;


Another example:

SELECT *
FROM employees
WHERE department = 'Finance'
OR department = 'Analytics'
AND salary > 60000;


When conditions become complex, use parentheses to make your intended logic explicit.

For example:

SELECT *
FROM employees
WHERE
(department = 'Finance' OR department = 'Analytics')
AND salary > 60000;


This means:



Employees from Finance or Analytics who earn more than 60,000.



๐Ÿ”น 17. Why Parentheses Matter

Consider:

WHERE city = 'Pune'
OR city = 'Mumbai'
AND age > 30


SQL's logical evaluation rules can make this behave differently from what a beginner might expect.

A safer and clearer version is:

WHERE
(city = 'Pune' OR city = 'Mumbai')
AND age > 30;


This clearly communicates the intended logic.

Best practice:



Use parentheses whenever combining AND and OR in a complex condition.



๐Ÿ”น 18. WHERE with Dates

You can also filter dates.

Example:

SELECT *
FROM orders
WHERE order_date >= '2026-01-01';


This retrieves orders on or after January 1, 2026.

Another example:

SELECT *
FROM orders
WHERE order_date < '2026-07-01';


This retrieves orders before July 1, 2026.

Date syntax can vary slightly across database systems, so always consider the SQL dialect you're using.

๐Ÿ”น 19. Filtering a Date Range

Suppose you want orders during a particular period.

You can use:

SELECT *
FROM orders
WHERE order_date >= '2026-01-01'
AND order_date < '2026-04-01';


This retrieves orders from January through March.

Using a half-open range like this is particularly useful when working with timestamps because it avoids accidentally excluding records with time components.

๐Ÿ”น 20. BETWEEN

SQL provides BETWEEN for range filtering.

Example:

SELECT *
FROM products
WHERE price BETWEEN 1000 AND 5000;


BETWEEN is inclusive of both boundaries in standard SQL.

So this includes:

1000

and:

5000

as well as values between them.

๐Ÿ”น 21. BETWEEN with Dates

Example:

SELECT *
FROM orders
WHERE order_date BETWEEN '2026-01-01' AND '2026-01-31';


For a date-only column, this can be useful.

However, if order_date contains timestamps, using:

order_date >= '2026-01-01'
AND order_date < '2026-02-01'


is often safer because it includes the entire final day regardless of the timestamp.

๐Ÿ”น 22. IN Operator

Suppose you want customers from:

Pune

Mumbai

Delhi

You could write:

SELECT *
FROM customers
WHERE city = 'Pune'
OR city = 'Mumbai'
OR city = 'Delhi';
Post #4631 1.05K
๐Ÿš€ Data Science Roadmap 2026

**

๐Ÿ“ Phase 3: SQL for Data Science**

๐Ÿ“– Topic 2: SQL Basics โ€” WHERE

After learning SELECT, the next essential SQL concept is WHERE.

In real-world Data Science, databases can contain millions or billions of records. You usually don't want to retrieve everything.

You want to answer questions such as:

Which customers are from Mumbai?

Which orders are above โ‚น10,000?

Which employees joined after 2023?

Which transactions were successful?

Which products belong to a particular category?

The WHERE clause allows you to filter rows based on conditions.

๐Ÿ”น 1. What Is WHERE?

WHERE is used to filter records based on a specified condition.

Basic syntax:

SELECT column1, column2
FROM table_name
WHERE condition;


Example:

SELECT *
FROM customers
WHERE city = 'Mumbai';


This returns only customers whose city is Mumbai.

๐Ÿ”น 2. WHERE with Text Values

Text values are generally written inside single quotes.

Example:

SELECT customer_id, name
FROM customers
WHERE city = 'Pune';


This retrieves customers from Pune.

Another example:

SELECT *
FROM employees
WHERE department = 'Finance';


๐Ÿ”น 3. WHERE with Numbers

For numeric values, quotes are generally not required.

Example:

SELECT *
FROM customers
WHERE age > 30;


This returns customers older than 30.

Another example:

SELECT *
FROM orders
WHERE amount > 10000;


This returns orders where the amount is greater than 10,000.

๐Ÿ”น 4. Comparison Operators

The most commonly used comparison operators are:

Operator Meaning

= Equal to

<> Not equal to

!= Not equal to



Greater than

< Less than

= Greater than or equal to

<= Less than or equal to



Example:

SELECT *
FROM employees
WHERE salary >= 50000;


This returns employees whose salary is at least 50,000.

๐Ÿ”น 5. Equal To =

The = operator checks whether two values are equal.

SELECT *
FROM customers
WHERE city = 'Delhi';


Only records where city equals Delhi are returned.

๐Ÿ”น 6. Not Equal <>

You can retrieve records that don't match a value.

SELECT *
FROM customers
WHERE city <> 'Delhi';


This returns customers whose city isn't Delhi.

You may also see:

WHERE city != 'Delhi'


Both are commonly supported, although <> is the standard SQL operator.

๐Ÿ”น 7. Greater Than >

Example:

SELECT *
FROM orders
WHERE amount > 50000;


Returns orders above 50,000.

๐Ÿ”น 8. Less Than <

Example:

SELECT *
FROM products
WHERE price < 1000;


Returns products priced below 1,000.

๐Ÿ”น 9. Greater Than or Equal To >=

Example:

SELECT *
FROM employees
WHERE experience >= 5;


This includes employees with exactly 5 years as well as those with more than 5 years.

๐Ÿ”น 10. Less Than or Equal To <=

Example:

SELECT *
FROM products
WHERE price <= 500;


This includes products priced exactly at 500.

๐Ÿ”น 11. WHERE with Multiple Conditions

Real-world queries often require more than one condition.

For this, SQL provides logical operators:

โ€ข AND

โ€ข OR

โ€ข NOT

๐Ÿ”น 12. AND

AND means all conditions must be true.

Example:

SELECT *
FROM customers
WHERE city = 'Pune'
AND age > 30;


This returns customers who:

1.

Are from Pune

2.

Are older than 30

Both conditions must be satisfied.

๐Ÿ”น 13. OR

OR means at least one condition must be true.

Example:
  • โค 1
Post #4630 1.64K
Soft skills questions will be part of your next data job interview!

Here is what you should prepare for:

1. ๐—–๐—ผ๐—บ๐—บ๐˜‚๐—ป๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป: Be ready to discuss how you explain complex data insights to non-technical stakeholders.

๐˜Œ๐˜น๐˜ข๐˜ฎ๐˜ฑ๐˜ญ๐˜ฆ ๐˜ฒ๐˜ถ๐˜ฆ๐˜ด๐˜ต๐˜ช๐˜ฐ๐˜ฏ:
โ€œHow do you ensure that your data insights are understood and get used by non-technical stakeholders?โ€

2. ๐—ง๐—ฒ๐—ฎ๐—บ ๐—–๐—ผ๐—น๐—น๐—ฎ๐—ฏ๐—ผ๐—ฟ๐—ฎ๐˜๐—ถ๐—ผ๐—ป: Show your ability to work well with others.

๐˜Œ๐˜น๐˜ข๐˜ฎ๐˜ฑ๐˜ญ๐˜ฆ ๐˜ฒ๐˜ถ๐˜ฆ๐˜ด๐˜ต๐˜ช๐˜ฐ๐˜ฏ:
โ€œCan you talk about a time when you had to manage a conflict within a team? How did you resolve it?โ€

3. ๐—ฃ๐—ฟ๐—ผ๐—ฏ๐—น๐—ฒ๐—บ-๐—ฆ๐—ผ๐—น๐˜ƒ๐—ถ๐—ป๐—ด: Highlight your critical thinking and problem-solving skills.

๐˜Œ๐˜น๐˜ข๐˜ฎ๐˜ฑ๐˜ญ๐˜ฆ ๐˜ฒ๐˜ถ๐˜ฆ๐˜ด๐˜ต๐˜ช๐˜ฐ๐˜ฏ:
โ€œDescribe a situation where you had to make a quick decision based on incomplete data. What was the outcome?โ€

4. ๐—”๐—ฑ๐—ฎ๐—ฝ๐˜๐—ฎ๐—ฏ๐—ถ๐—น๐—ถ๐˜๐˜†: Demonstrate your flexibility and openness to change.

๐˜Œ๐˜น๐˜ข๐˜ฎ๐˜ฑ๐˜ญ๐˜ฆ ๐˜ฒ๐˜ถ๐˜ฆ๐˜ด๐˜ต๐˜ช๐˜ฐ๐˜ฏ:
โ€œHow do you handle sudden changes in project priorities or scope?โ€

5. ๐—ง๐—ถ๐—บ๐—ฒ ๐— ๐—ฎ๐—ป๐—ฎ๐—ด๐—ฒ๐—บ๐—ฒ๐—ป๐˜: Prove your ability to manage multiple tasks and deadlines.

๐˜Œ๐˜น๐˜ข๐˜ฎ๐˜ฑ๐˜ญ๐˜ฆ ๐˜ฒ๐˜ถ๐˜ฆ๐˜ด๐˜ต๐˜ช๐˜ฐ๐˜ฏ:
โ€œTell me about a time when you were under tight deadlines. How did you manage to meet them?โ€

6. ๐—˜๐—บ๐—ฝ๐—ฎ๐˜๐—ต๐˜† ๐—ฎ๐—ป๐—ฑ ๐—จ๐—ป๐—ฑ๐—ฒ๐—ฟ๐˜€๐˜๐—ฎ๐—ป๐—ฑ๐—ถ๐—ป๐—ด: Show your ability to understand stakeholder needs.

๐˜Œ๐˜น๐˜ข๐˜ฎ๐˜ฑ๐˜ญ๐˜ฆ ๐˜ฒ๐˜ถ๐˜ฆ๐˜ด๐˜ต๐˜ช๐˜ฐ๐˜ฏ:
โ€œHow do you approach understanding the needs of different stakeholders when starting a new project?โ€


Structure your answers using the STAR method (Situation, Task, Action, Result). This helps you provide clear and concise responses that highlight your skills.

By preparing for these soft skills questions, youโ€™ll demonstrate that youโ€™re not just technically fit, but also a well-rounded professional ready to make an impact on the business.

You can find useful tips to improve your soft skills here: ๐Ÿ‘‡ https://t.me/englishlearnerspro/
  • โค 8
Older posts โ†’

About this channel

How can I read @datasciencefun without a Telegram account?
TGViewer shows the public web preview Telegram publishes for Data Science & Machine Learning: recent posts, photos, videos and the subscriber count, with no app, login or account.
How many subscribers does Data Science & Machine Learning have?
Data Science & Machine Learning (@datasciencefun) has 77.7K subscribers on Telegram, refreshed roughly every 30 minutes.
Does Data Science & Machine Learning know I viewed it here?
No. Public channel previews carry no viewer identity, and TGViewer has no accounts or tracking of what you look up.
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook โ†’Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 โ†’