GigaChat 3.5 Ultra Publicly Released โ The New Generation of the Flagship Model
Whatโs inside:
๐ A proprietary hybrid MLA + Gated DeltaNet architecture with a dedicated stabilization framework, without which this hybrid setup would not train reliably at this scale;
๐ Gated Attention: the model can locally down-weight overly strong signals from the attention layer;
๐ GatedNorm: normalization with an explicit gate that controls signal magnitude across features;
๐ Approximately 4x lower KV cache per token: with the same memory budget, the model can support 2.14x longer context and deliver a 20% throughput increase under load;
๐ Two MTP heads, enabling up to 2.2x faster generation;
๐ FP8 across all training stages with no quality degradation compared with bf16, enabled by custom Triton and CUDA kernels;
๐ A new online RL stage after SFT and DPO.
Results:
๐ GigaChat-3.5-Ultra-Base outperforms DeepSeek V3.2 Exp Base and DeepSeek V4 Flash Base on average across a set of general, math, and code benchmarks:
๐ GigaChat-3.5-Ultra-Instruct is comparable to DeepSeek V3.2 in terms of average score, despite having half the size;
๐ According to the MiniMax-M2.7 LLM judge, the average win rate against GigaChat 3.1 Ultra is 75.9%, and against GPT-5 is 68.7%.
โก๏ธ HuggingFace
The GigaChat team has released GigaChat 3.5 Ultra as open sourceโa new 432B model under the MIT license. This is the first open-source hybrid of GatedDeltaNet and MLA scaled to hundreds of billions of parameters, featuring a proprietary training recipe we refined through more than 1,500 experiments. The model has grown in terms of code, mathematics, agent scenarios, and application domainsโyet itโs 40% smaller than GigaChat 3.1 Ultra.
Whatโs inside:
Results:
The entire stack โ data (our own LLM-filtered Common Crawl, 600+ programming languages in the code), architecture, training methodology, and infrastructure โ was built end-to-end by GigaChat team.
Please open Telegram to view this post
VIEW IN TELEGRAM
โค3
๐ ๐๐ฅ๐๐ ๐ ๐ถ๐ฐ๐ฟ๐ผ๐๐ผ๐ณ๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐ป๐ฅ
These FREE courses can help you learn Data Analytics, Power BI & Excel skills that companies actually hire for ๐
โจ What youโll learn:
โ Excel + Power BI ๐
โ Data Cleaning with Power Query
โ Interactive Dashboards
โ Modern Analytics Skills
๐ฏ Beginner Friendly + FREE Learning
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4tkPNyM
๐ Perfect for Students, Freshers & Career Switchers
These FREE courses can help you learn Data Analytics, Power BI & Excel skills that companies actually hire for ๐
โจ What youโll learn:
โ Excel + Power BI ๐
โ Data Cleaning with Power Query
โ Interactive Dashboards
โ Modern Analytics Skills
๐ฏ Beginner Friendly + FREE Learning
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4tkPNyM
๐ Perfect for Students, Freshers & Career Switchers
โ
Power BI Interview Questions with Answers
1. What is DAX?
DAX (Data Analysis Expressions) is a formula language in Power BI used to create calculated columns, measures, and tables (e.g., SUM(), CALCULATE(), FILTER()) for business logic and KPIs.
2. What is the difference between Power Query and Power Pivot?
โข Power Query: used for data loading, cleaning, and transforming (ETL) before loading into the model.
โข Power Pivot: inโmemory data model and engine for DAX calculations and relationships (used during/after load).
3. What is the difference between measure vs calculated column?
โข Measure: calculated at query time, used in visuals (e.g., summaries, ratios).
โข Calculated column: computed at refresh time, stored in the model (uses more memory). Prefer measures for aggregations.
4. Explain CALCULATE() function.
CALCULATE() changes the context of a calculation by applying filters.
Example: Total Sales = CALCULATE(SUM(Sales[Amount]), Sales[Region] = "West") computes sum only for West region.
5. What are relationships (1:M, M:M)?
โข 1:M (oneโtoโmany): one row in the โ1โ table links to many rows in the โMโ table (most common).
โข M:M (manyโtoโmany): handled via an intermediate bridge table with foreign keys on both sides.
6. How do you handle manyโtoโmany?
Create a bridge table (junction table) that contains foreign keys to both related tables. Then set 1:M relationships from each original table to the bridge.
7. What is rowโlevel security (RLS)?
RLS restricts which rows a user can see in a report (e.g., by SalesRegion = โUserRegionโ). Defined in the model with DAX filter expressions and applied by user roles.
8. How do you setup incremental refresh?
โข Mark your tables as โincrementally refreshableโ in the model.
โข Define a date/time column and ranges (e.g., last 3 years full, last 60 days incremental).
โข Set refresh schedule in the Power BI service with gateways if needed.
9. What is the difference between filters vs slicers?
โข Filters: rules applied behind the scenes (e.g., in page/report level filters) that always apply.
โข Slicers: interactive controls on the report canvas that users click to change what data is shown.
10. What is a data model?
A data model is the structure in Power BI that holds tables, relationships, calculated columns, measures, and hierarchies, forming the semantic layer for reporting.
11. How do you publish and share reports?
โข Publish from Power BI Desktop to a workspace in Power BI Service.
โข Share via apps, workspaces, or by granting access to specific users/groups; use RLS and sharing permissions to control who sees what.
12. What is Performance Analyzer tool?
Performance Analyzer in Power BI Desktop records how long each visual takes to render and which DAX queries run, helping identify slow visuals or large queries.
13. How do you create monthโonโmonth growth DAX?
MoM Growth =
VAR CurrentSales = [Total Sales]
VAR PreviousSales = CALCULATE([Total Sales], DATEADD('Date'[Date], -1, MONTH))
RETURN
DIVIDE(CurrentSales - PreviousSales, PreviousSales)
14. How do you use custom visuals?
Download a custom visual from the marketplace, add it to the report in Power BI Desktop or Service, then configure like a native visual (fields, formatting, interactivity).
15. What is gateway for refresh?
An onโpremises gateway connects Power BI Service to data sources behind your firewall (e.g., SQL Server, file shares). It enables scheduled refresh for datasets that pull from those sources.
16. What is a .pbix file?
A .pbix file is the Power BI Desktop project file that contains the report layout, queries, data model, and DAX logic. It can be opened in Power BI Desktop or published to the service.
17. What are quick measures examples?
Quick measures are autoโgenerated DAX calculations with a UI. Examples:
โข Average of a column.
1. What is DAX?
DAX (Data Analysis Expressions) is a formula language in Power BI used to create calculated columns, measures, and tables (e.g., SUM(), CALCULATE(), FILTER()) for business logic and KPIs.
2. What is the difference between Power Query and Power Pivot?
โข Power Query: used for data loading, cleaning, and transforming (ETL) before loading into the model.
โข Power Pivot: inโmemory data model and engine for DAX calculations and relationships (used during/after load).
3. What is the difference between measure vs calculated column?
โข Measure: calculated at query time, used in visuals (e.g., summaries, ratios).
โข Calculated column: computed at refresh time, stored in the model (uses more memory). Prefer measures for aggregations.
4. Explain CALCULATE() function.
CALCULATE() changes the context of a calculation by applying filters.
Example: Total Sales = CALCULATE(SUM(Sales[Amount]), Sales[Region] = "West") computes sum only for West region.
5. What are relationships (1:M, M:M)?
โข 1:M (oneโtoโmany): one row in the โ1โ table links to many rows in the โMโ table (most common).
โข M:M (manyโtoโmany): handled via an intermediate bridge table with foreign keys on both sides.
6. How do you handle manyโtoโmany?
Create a bridge table (junction table) that contains foreign keys to both related tables. Then set 1:M relationships from each original table to the bridge.
7. What is rowโlevel security (RLS)?
RLS restricts which rows a user can see in a report (e.g., by SalesRegion = โUserRegionโ). Defined in the model with DAX filter expressions and applied by user roles.
8. How do you setup incremental refresh?
โข Mark your tables as โincrementally refreshableโ in the model.
โข Define a date/time column and ranges (e.g., last 3 years full, last 60 days incremental).
โข Set refresh schedule in the Power BI service with gateways if needed.
9. What is the difference between filters vs slicers?
โข Filters: rules applied behind the scenes (e.g., in page/report level filters) that always apply.
โข Slicers: interactive controls on the report canvas that users click to change what data is shown.
10. What is a data model?
A data model is the structure in Power BI that holds tables, relationships, calculated columns, measures, and hierarchies, forming the semantic layer for reporting.
11. How do you publish and share reports?
โข Publish from Power BI Desktop to a workspace in Power BI Service.
โข Share via apps, workspaces, or by granting access to specific users/groups; use RLS and sharing permissions to control who sees what.
12. What is Performance Analyzer tool?
Performance Analyzer in Power BI Desktop records how long each visual takes to render and which DAX queries run, helping identify slow visuals or large queries.
13. How do you create monthโonโmonth growth DAX?
MoM Growth =
VAR CurrentSales = [Total Sales]
VAR PreviousSales = CALCULATE([Total Sales], DATEADD('Date'[Date], -1, MONTH))
RETURN
DIVIDE(CurrentSales - PreviousSales, PreviousSales)
14. How do you use custom visuals?
Download a custom visual from the marketplace, add it to the report in Power BI Desktop or Service, then configure like a native visual (fields, formatting, interactivity).
15. What is gateway for refresh?
An onโpremises gateway connects Power BI Service to data sources behind your firewall (e.g., SQL Server, file shares). It enables scheduled refresh for datasets that pull from those sources.
16. What is a .pbix file?
A .pbix file is the Power BI Desktop project file that contains the report layout, queries, data model, and DAX logic. It can be opened in Power BI Desktop or published to the service.
17. What are quick measures examples?
Quick measures are autoโgenerated DAX calculations with a UI. Examples:
โข Average of a column.
โค3
๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐๐ฅ๐๐ ๐ข๐ป๐น๐ถ๐ป๐ฒ ๐ ๐ฎ๐๐๐ฒ๐ฟ๐ฐ๐น๐ฎ๐๐ ๐
๐ซ Know The Tools, Skills & Mindset to Land your first Job
โ
๐ซUnderstand the Foundations, tools, skills & the core essentials that you need to excel in the Data Science domain.
Eligibility :- Students ,Freshers & Working Professionals
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐๐ผ๐ฟ ๐๐ฅ๐๐๐ :-
https://pdlink.in/4btjs2G
( Limited Slots ..Hurry Upโ )
Date & Time :- 17th July 2026 , 7:00 PM
๐ซ Know The Tools, Skills & Mindset to Land your first Job
โ
๐ซUnderstand the Foundations, tools, skills & the core essentials that you need to excel in the Data Science domain.
Eligibility :- Students ,Freshers & Working Professionals
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐๐ผ๐ฟ ๐๐ฅ๐๐๐ :-
https://pdlink.in/4btjs2G
( Limited Slots ..Hurry Upโ )
Date & Time :- 17th July 2026 , 7:00 PM
โค1
๐ ๐ฒ ๐ ๐๐๐-๐ง๐ฎ๐ธ๐ฒ ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐ง๐ผ ๐จ๐ฝ๐ด๐ฟ๐ฎ๐ฑ๐ฒ ๐ฌ๐ผ๐๐ฟ ๐ฅ๐ฒ๐๐๐บ๐ฒ ๐๐ข๐ฅ ๐๐ฅ๐๐
Make your resume stand out to recruiters without spending a single rupee
โ 100% FREE Learning
โ Free Certificates
โ Beginner-Friendly
โ Self-Paced Learning
โ Resume & LinkedIn Boost
โ Industry-Relevant Skills
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/3Rmbzp1
๐ Learn for Free. Get Certified. Upgrade Your Resume. Land Your Dream Job!
Make your resume stand out to recruiters without spending a single rupee
โ 100% FREE Learning
โ Free Certificates
โ Beginner-Friendly
โ Self-Paced Learning
โ Resume & LinkedIn Boost
โ Industry-Relevant Skills
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/3Rmbzp1
๐ Learn for Free. Get Certified. Upgrade Your Resume. Land Your Dream Job!
11 Quick tips to improve your data interpretation skills
Hands-On Projects: Work on real-world projects that involve analyzing data. This could be personal projects or participating in online competitions like Kaggle. Practical experience will enhance your skills.
Data Visualization: Practice creating various types of charts and graphs to visually represent data. Tools like Tableau or Python's matplotlib/seaborn libraries can help.
Storytelling with Data: Practice presenting your findings in a clear and compelling manner. Communicating insights effectively is crucial in data interpretation.
Data Challenges: Engage in data challenges or puzzles that require you to manipulate and interpret data. Websites like Project Euler or DataCamp offer such challenges.
Case Studies: Study existing data analysis case studies to understand how experts approach and interpret data. This can provide insights into different methodologies.
Mentorship: Seek guidance from experienced data analysts or scientists. Learning from their experiences and feedback can accelerate your growth.
Critical Thinking: Practice questioning the data and assumptions underlying your analysis. Developing a critical mindset will help you identify potential errors or biases.
Domain Expertise: Choose a specific field of interest and delve deep into its data. Becoming knowledgeable about the domain will enhance your ability to extract meaningful insights.
Experimentation: Try different analysis techniques, algorithms, and approaches to see what works best for different types of data and questions.
Peer Collaboration: Join or create study groups with peers who share your interest in data analysis. Discussing different approaches and sharing insights can be invaluable.
Feedback Loop: Continuously seek feedback on your work. Constructive criticism can help you refine your skills and identify areas for improvement.
Remember that improving data interpretation skills is an ongoing process. Be patient, persistent, and open to learning from your experiences and mistakes :)
Hands-On Projects: Work on real-world projects that involve analyzing data. This could be personal projects or participating in online competitions like Kaggle. Practical experience will enhance your skills.
Data Visualization: Practice creating various types of charts and graphs to visually represent data. Tools like Tableau or Python's matplotlib/seaborn libraries can help.
Storytelling with Data: Practice presenting your findings in a clear and compelling manner. Communicating insights effectively is crucial in data interpretation.
Data Challenges: Engage in data challenges or puzzles that require you to manipulate and interpret data. Websites like Project Euler or DataCamp offer such challenges.
Case Studies: Study existing data analysis case studies to understand how experts approach and interpret data. This can provide insights into different methodologies.
Mentorship: Seek guidance from experienced data analysts or scientists. Learning from their experiences and feedback can accelerate your growth.
Critical Thinking: Practice questioning the data and assumptions underlying your analysis. Developing a critical mindset will help you identify potential errors or biases.
Domain Expertise: Choose a specific field of interest and delve deep into its data. Becoming knowledgeable about the domain will enhance your ability to extract meaningful insights.
Experimentation: Try different analysis techniques, algorithms, and approaches to see what works best for different types of data and questions.
Peer Collaboration: Join or create study groups with peers who share your interest in data analysis. Discussing different approaches and sharing insights can be invaluable.
Feedback Loop: Continuously seek feedback on your work. Constructive criticism can help you refine your skills and identify areas for improvement.
Remember that improving data interpretation skills is an ongoing process. Be patient, persistent, and open to learning from your experiences and mistakes :)
โค3๐1
๐๐ & ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ (๐ก๐ผ ๐๐ผ๐ฑ๐ถ๐ป๐ด ๐ก๐ฒ๐ฒ๐ฑ๐ฒ๐ฑ)
Apply Now๐:- https://pdlink.in/4aYWald
By E&ICT Academy, IIT Roorkee
Batch Closing Soon - 18th July 2026
Apply Now๐:- https://pdlink.in/4aYWald
By E&ICT Academy, IIT Roorkee
Batch Closing Soon - 18th July 2026
โค1
๐ฅ SQL Interview Case Studies & Real-World Business Problems
๐ง Case Study 1: Top 3 Customers by Revenue
๐ Orders Table
order_id customer_id amount
1 101 500
2 102 1000
3 101 700
โ Business Question
Find the top 3 customers by total revenue.
โ Solution
SELECT customer_id,
SUM(amount) AS total_revenue
FROM orders
GROUP BY customer_id
ORDER BY total_revenue DESC
LIMIT 3;
๐ง Case Study 2: Department with Highest Average Salary
โ Business Question
Which department has the highest average salary?
โ Solution
SELECT department,
AVG(salary) AS avg_salary
FROM employees
GROUP BY department
ORDER BY avg_salary DESC
LIMIT 1;
๐ง Case Study 3: Customers Who Never Ordered
๐ Tables
Customers customer_id name
Orders order_id customer_id
โ Business Question
Find customers who never placed an order.
โ Solution
SELECT c.customer_id,
c.name
FROM customers c
LEFT JOIN orders o
ON c.customer_id = o.customer_id
WHERE o.customer_id IS NULL;
๐ง Case Study 4: Second Highest Salary
โ Business Question
Find employees with the second highest salary.
โ Solution
SELECT *
FROM employees
WHERE salary = (
SELECT MAX(salary)
FROM employees
WHERE salary < (
SELECT MAX(salary)
FROM employees
)
);
๐ง Case Study 5: Monthly Sales Trend
โ Business Question
Calculate monthly sales.
โ Solution
SELECT YEAR(order_date) AS year,
MONTH(order_date) AS month,
SUM(amount) AS sales
FROM orders
GROUP BY YEAR(order_date),
MONTH(order_date)
ORDER BY year, month;
๐ฏ Practice Tasks
1๏ธโฃ Find top-selling product
2๏ธโฃ Find employee with highest salary in each department
3๏ธโฃ Find customers with more than 5 orders
4๏ธโฃ Find month with highest sales
5๏ธโฃ Find departments having more than 10 employees
โก Mini Challenge ๐ฅ
E-commerce Scenario
Tables:
Customers customer_id name
Orders order_id customer_id amount order_date
Business Question
Find the top 5 customers by total spending in the last 12 months.
๐ฅ Interview Tip
Most SQL interviews are NOT about syntax.
They're about:
โ Understanding business problem
โ Choosing the right approach
โ Writing efficient SQL
Double Tap โค๏ธ For More
๐ง Case Study 1: Top 3 Customers by Revenue
๐ Orders Table
order_id customer_id amount
1 101 500
2 102 1000
3 101 700
โ Business Question
Find the top 3 customers by total revenue.
โ Solution
SELECT customer_id,
SUM(amount) AS total_revenue
FROM orders
GROUP BY customer_id
ORDER BY total_revenue DESC
LIMIT 3;
๐ง Case Study 2: Department with Highest Average Salary
โ Business Question
Which department has the highest average salary?
โ Solution
SELECT department,
AVG(salary) AS avg_salary
FROM employees
GROUP BY department
ORDER BY avg_salary DESC
LIMIT 1;
๐ง Case Study 3: Customers Who Never Ordered
๐ Tables
Customers customer_id name
Orders order_id customer_id
โ Business Question
Find customers who never placed an order.
โ Solution
SELECT c.customer_id,
c.name
FROM customers c
LEFT JOIN orders o
ON c.customer_id = o.customer_id
WHERE o.customer_id IS NULL;
๐ง Case Study 4: Second Highest Salary
โ Business Question
Find employees with the second highest salary.
โ Solution
SELECT *
FROM employees
WHERE salary = (
SELECT MAX(salary)
FROM employees
WHERE salary < (
SELECT MAX(salary)
FROM employees
)
);
๐ง Case Study 5: Monthly Sales Trend
โ Business Question
Calculate monthly sales.
โ Solution
SELECT YEAR(order_date) AS year,
MONTH(order_date) AS month,
SUM(amount) AS sales
FROM orders
GROUP BY YEAR(order_date),
MONTH(order_date)
ORDER BY year, month;
๐ฏ Practice Tasks
1๏ธโฃ Find top-selling product
2๏ธโฃ Find employee with highest salary in each department
3๏ธโฃ Find customers with more than 5 orders
4๏ธโฃ Find month with highest sales
5๏ธโฃ Find departments having more than 10 employees
โก Mini Challenge ๐ฅ
E-commerce Scenario
Tables:
Customers customer_id name
Orders order_id customer_id amount order_date
Business Question
Find the top 5 customers by total spending in the last 12 months.
๐ฅ Interview Tip
Most SQL interviews are NOT about syntax.
They're about:
โ Understanding business problem
โ Choosing the right approach
โ Writing efficient SQL
Double Tap โค๏ธ For More
โค6
๐ ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ ๐๐ฅ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐
Data Analytics is one of the most in-demand skills in todayโs job market ๐ป
โ Beginner Friendly
โ Industry-Relevant Curriculum
โ Certification Included
โ 100% Online
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4wh2ugB
๐ฏ Donโt miss this opportunity to build high-demand skills!
Data Analytics is one of the most in-demand skills in todayโs job market ๐ป
โ Beginner Friendly
โ Industry-Relevant Curriculum
โ Certification Included
โ 100% Online
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4wh2ugB
๐ฏ Donโt miss this opportunity to build high-demand skills!
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ:
You have 2 minutes to solve this SQL query.
Find employees who earn the same salary as at least one other employee in the same department.
๐ ๐ฒ: Challenge accepted! ๐ช
SELECT
employee_id,
employee_name,
department,
salary
FROM employees
WHERE (department, salary) IN (
SELECT
department,
salary
FROM employees
GROUP BY department, salary
HAVING COUNT(*) > 1
)
ORDER BY department, salary DESC;
๐ก Explanation:
The query identifies duplicate salary values within each department.
โข The subquery groups records by department and salary.
โข **HAVING COUNT(*) > 1** finds salary values that appear more than once in the same department.
โข The outer query returns all employees whose (department, salary) matches those duplicate combinations.
This question tests your understanding of:
โ GROUP BY
โ HAVING
โ Multi-column filtering
โ Identifying duplicate records
๐ฏ Expected Output Example
Employee Department Salary
John IT 80,000
Alice IT 80,000
David HR 65,000
Sarah HR 65,000
๐ Alternative Using Window Functions
SELECT
employee_id,
employee_name,
department,
salary
FROM (
SELECT
*,
COUNT(*) OVER (
PARTITION BY department, salary
) AS salary_count
FROM employees
) t
WHERE salary_count > 1;
This approach avoids a subquery with GROUP BY and is a great way to showcase your knowledge of window functions.
๐ When interview questions ask you to find duplicates, think of these three approaches:
1. GROUP BY + HAVING
2. Window functions COUNT() OVER
3. Self Join for specific comparison scenarios
Knowing multiple solutions demonstrates strong SQL problem-solving skills.
โค๏ธ React with โค๏ธ for more SQL interview challenges!
You have 2 minutes to solve this SQL query.
Find employees who earn the same salary as at least one other employee in the same department.
๐ ๐ฒ: Challenge accepted! ๐ช
SELECT
employee_id,
employee_name,
department,
salary
FROM employees
WHERE (department, salary) IN (
SELECT
department,
salary
FROM employees
GROUP BY department, salary
HAVING COUNT(*) > 1
)
ORDER BY department, salary DESC;
๐ก Explanation:
The query identifies duplicate salary values within each department.
โข The subquery groups records by department and salary.
โข **HAVING COUNT(*) > 1** finds salary values that appear more than once in the same department.
โข The outer query returns all employees whose (department, salary) matches those duplicate combinations.
This question tests your understanding of:
โ GROUP BY
โ HAVING
โ Multi-column filtering
โ Identifying duplicate records
๐ฏ Expected Output Example
Employee Department Salary
John IT 80,000
Alice IT 80,000
David HR 65,000
Sarah HR 65,000
๐ Alternative Using Window Functions
SELECT
employee_id,
employee_name,
department,
salary
FROM (
SELECT
*,
COUNT(*) OVER (
PARTITION BY department, salary
) AS salary_count
FROM employees
) t
WHERE salary_count > 1;
This approach avoids a subquery with GROUP BY and is a great way to showcase your knowledge of window functions.
๐ When interview questions ask you to find duplicates, think of these three approaches:
1. GROUP BY + HAVING
2. Window functions COUNT() OVER
3. Self Join for specific comparison scenarios
Knowing multiple solutions demonstrates strong SQL problem-solving skills.
โค๏ธ React with โค๏ธ for more SQL interview challenges!
โค6
๐ ๐๐ & ๐ ๐ฎ๐ฐ๐ต๐ถ๐ป๐ฒ ๐๐ฒ๐ฎ๐ฟ๐ป๐ถ๐ป๐ด ๐๐ฅ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐ฅ
Learn the most in-demand AI skills from scratch and strengthen your profile with industry-recognized certificates! ๐
โ Beginner-Friendly Courses
โ Learn Online at Your Own Pace
โ 100% FREE of cost
Perfect for Students, Freshers & Working Professionals looking to build a career in AI/ML. ๐ผ
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4phANS2
๐ข Share this with your friends who want to start their AI career!
Learn the most in-demand AI skills from scratch and strengthen your profile with industry-recognized certificates! ๐
โ Beginner-Friendly Courses
โ Learn Online at Your Own Pace
โ 100% FREE of cost
Perfect for Students, Freshers & Working Professionals looking to build a career in AI/ML. ๐ผ
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4phANS2
๐ข Share this with your friends who want to start their AI career!
๐ Best Data Analytics Roles Based on Your Graduation Background!
Thinking about a career in Data Analytics but unsure which role fits your background? Check out these top job roles based on your degree:
๐ For Mathematics/Statistics Graduates:
๐น Data Analyst
๐น Statistical Analyst
๐น Quantitative Analyst
๐น Risk Analyst
๐ For Computer Science/IT Graduates:
๐น Data Scientist
๐น Business Intelligence Developer
๐น Data Engineer
๐น Data Architect
๐ For Economics/Finance Graduates:
๐น Financial Analyst
๐น Market Research Analyst
๐น Economic Consultant
๐น Data Journalist
๐ For Business/Management Graduates:
๐น Business Analyst
๐น Operations Research Analyst
๐น Marketing Analytics Manager
๐น Supply Chain Analyst
๐ For Engineering Graduates:
๐น Data Scientist
๐น Industrial Engineer
๐น Operations Research Analyst
๐น Quality Engineer
๐ For Social Science Graduates:
๐น Data Analyst
๐น Research Assistant
๐น Social Media Analyst
๐น Public Health Analyst
๐ For Biology/Healthcare Graduates:
๐น Clinical Data Analyst
๐น Biostatistician
๐น Research Coordinator
๐น Healthcare Consultant
โ Pro Tip:
Some of these roles may require additional certifications or upskilling in SQL, Python, Power BI, Tableau, or Machine Learning to stand out in the job market.
Like if it helps โค๏ธ
Thinking about a career in Data Analytics but unsure which role fits your background? Check out these top job roles based on your degree:
๐ For Mathematics/Statistics Graduates:
๐น Data Analyst
๐น Statistical Analyst
๐น Quantitative Analyst
๐น Risk Analyst
๐ For Computer Science/IT Graduates:
๐น Data Scientist
๐น Business Intelligence Developer
๐น Data Engineer
๐น Data Architect
๐ For Economics/Finance Graduates:
๐น Financial Analyst
๐น Market Research Analyst
๐น Economic Consultant
๐น Data Journalist
๐ For Business/Management Graduates:
๐น Business Analyst
๐น Operations Research Analyst
๐น Marketing Analytics Manager
๐น Supply Chain Analyst
๐ For Engineering Graduates:
๐น Data Scientist
๐น Industrial Engineer
๐น Operations Research Analyst
๐น Quality Engineer
๐ For Social Science Graduates:
๐น Data Analyst
๐น Research Assistant
๐น Social Media Analyst
๐น Public Health Analyst
๐ For Biology/Healthcare Graduates:
๐น Clinical Data Analyst
๐น Biostatistician
๐น Research Coordinator
๐น Healthcare Consultant
โ Pro Tip:
Some of these roles may require additional certifications or upskilling in SQL, Python, Power BI, Tableau, or Machine Learning to stand out in the job market.
Like if it helps โค๏ธ
โค6
๐ ๐๐ถ๐๐ฐ๐ผ ๐๐ฅ๐๐ ๐ง๐ฒ๐ฐ๐ต ๐๐ผ๐๐ฟ๐๐ฒ๐ | ๐ฑ ๐ ๐๐๐-๐๐ผ ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐
Cisco offers learning opportunities covering some of the most valuable foundations for careers in Cybersecurity, Networking, Linux and IoT.
โ Beginner-Friendly Tech Skills
โ Learn In-Demand IT Concepts
โ Build Practical Knowledge
โ Strengthen Your Resume
โ Great for Students & Freshers
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4fhCSKo
๐ฅ Learn from Cisco โข Build Skills โข Upgrade Your Resume โข Get Career-Ready!
Cisco offers learning opportunities covering some of the most valuable foundations for careers in Cybersecurity, Networking, Linux and IoT.
โ Beginner-Friendly Tech Skills
โ Learn In-Demand IT Concepts
โ Build Practical Knowledge
โ Strengthen Your Resume
โ Great for Students & Freshers
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4fhCSKo
๐ฅ Learn from Cisco โข Build Skills โข Upgrade Your Resume โข Get Career-Ready!
โค1
Complete Excel Topics for Data Analysts ๐๐
MS Excel Free Resources
-> https://t.me/excel_data
1. Introduction to Excel:
- Basic spreadsheet navigation
- Understanding cells, rows, and columns
2. Data Entry and Formatting:
- Entering and formatting data
- Cell styles and formatting options
3. Formulas and Functions:
- Basic arithmetic functions
- SUM, AVERAGE, COUNT functions
4. Data Cleaning and Validation:
- Removing duplicates
- Data validation techniques
5. Sorting and Filtering:
- Sorting data
- Using filters for data analysis
6. Charts and Graphs:
- Creating basic charts (bar, line, pie)
- Customizing and formatting charts
7. PivotTables and PivotCharts:
- Creating PivotTables
- Analyzing data with PivotCharts
8. Advanced Formulas:
- VLOOKUP, HLOOKUP, INDEX-MATCH
- IF statements for conditional logic
9. Data Analysis with What-If Analysis:
- Goal Seek
- Scenario Manager and Data Tables
10. Advanced Charting Techniques:
- Combination charts
- Dynamic charts with named ranges
11. Power Query:
- Importing and transforming data with Power Query
12. Data Visualization with Power BI:
- Connecting Excel to Power BI
- Creating interactive dashboards
13. Macros and Automation:
- Recording and running macros
- Automation with VBA (Visual Basic for Applications)
14. Advanced Data Analysis:
- Regression analysis
- Data forecasting with Excel
15. Collaboration and Sharing:
- Excel sharing options
- Collaborative editing and comments
16. Excel Shortcuts and Productivity Tips:
- Time-saving keyboard shortcuts
- Productivity tips for efficient work
17. Data Import and Export:
- Importing and exporting data to/from Excel
18. Data Security and Protection:
- Password protection
- Worksheet and workbook security
19. Excel Add-Ins:
- Using and installing Excel add-ins for extended functionality
20. Mastering Excel for Data Analysis:
- Comprehensive project or case study integrating various Excel skills
Since Excel is another essential skill for data analysts, I have decided to teach each topic daily in this channel for free. Like this post if you want me to continue this Excel series ๐โฅ๏ธ
Share with credits: https://t.me/sqlspecialist
Hope it helps :)
MS Excel Free Resources
-> https://t.me/excel_data
1. Introduction to Excel:
- Basic spreadsheet navigation
- Understanding cells, rows, and columns
2. Data Entry and Formatting:
- Entering and formatting data
- Cell styles and formatting options
3. Formulas and Functions:
- Basic arithmetic functions
- SUM, AVERAGE, COUNT functions
4. Data Cleaning and Validation:
- Removing duplicates
- Data validation techniques
5. Sorting and Filtering:
- Sorting data
- Using filters for data analysis
6. Charts and Graphs:
- Creating basic charts (bar, line, pie)
- Customizing and formatting charts
7. PivotTables and PivotCharts:
- Creating PivotTables
- Analyzing data with PivotCharts
8. Advanced Formulas:
- VLOOKUP, HLOOKUP, INDEX-MATCH
- IF statements for conditional logic
9. Data Analysis with What-If Analysis:
- Goal Seek
- Scenario Manager and Data Tables
10. Advanced Charting Techniques:
- Combination charts
- Dynamic charts with named ranges
11. Power Query:
- Importing and transforming data with Power Query
12. Data Visualization with Power BI:
- Connecting Excel to Power BI
- Creating interactive dashboards
13. Macros and Automation:
- Recording and running macros
- Automation with VBA (Visual Basic for Applications)
14. Advanced Data Analysis:
- Regression analysis
- Data forecasting with Excel
15. Collaboration and Sharing:
- Excel sharing options
- Collaborative editing and comments
16. Excel Shortcuts and Productivity Tips:
- Time-saving keyboard shortcuts
- Productivity tips for efficient work
17. Data Import and Export:
- Importing and exporting data to/from Excel
18. Data Security and Protection:
- Password protection
- Worksheet and workbook security
19. Excel Add-Ins:
- Using and installing Excel add-ins for extended functionality
20. Mastering Excel for Data Analysis:
- Comprehensive project or case study integrating various Excel skills
Since Excel is another essential skill for data analysts, I have decided to teach each topic daily in this channel for free. Like this post if you want me to continue this Excel series ๐โฅ๏ธ
Share with credits: https://t.me/sqlspecialist
Hope it helps :)
๐๐ & ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ (๐ก๐ผ ๐๐ผ๐ฑ๐ถ๐ป๐ด ๐ก๐ฒ๐ฒ๐ฑ๐ฒ๐ฑ)
Apply Now๐:- https://pdlink.in/4aYWald
By E&ICT Academy, IIT Roorkee
Batch Closing Soon - 26th July 2026
Apply Now๐:- https://pdlink.in/4aYWald
By E&ICT Academy, IIT Roorkee
Batch Closing Soon - 26th July 2026
โ
๐ค AโZ of SQL Commands ๐๏ธ๐ปโก
A โ ALTER
Modify an existing table structure (add/modify/drop columns).
B โ BEGIN
Start a transaction block.
C โ CREATE
Create database objects like tables, views, indexes.
D โ DELETE
Remove records from a table.
E โ EXISTS
Check if a subquery returns any rows.
F โ FETCH
Retrieve rows from a cursor.
G โ GRANT
Give privileges to users.
H โ HAVING
Filter aggregated results (used with GROUP BY).
I โ INSERT
Add new records into a table.
J โ JOIN
Combine rows from two or more tables.
K โ KEY (PRIMARY KEY / FOREIGN KEY)
Define constraints for uniqueness and relationships.
L โ LIMIT
Restrict number of rows returned (MySQL/PostgreSQL).
M โ MERGE
Insert/update data conditionally (mainly in SQL Server/Oracle).
N โ NULL
Represents missing or unknown data.
O โ ORDER BY
Sort query results.
P โ PROCEDURE
Stored program in the database.
Q โ QUERY
Request for data (general SQL statement).
R โ ROLLBACK
Undo changes in a transaction.
S โ SELECT
Retrieve data from tables.
T โ TRUNCATE
Remove all records from a table quickly.
U โ UPDATE
Modify existing records.
V โ VIEW
Virtual table based on a query.
W โ WHERE
Filter records based on conditions.
X โ XML PATH
Generate XML output (mainly SQL Server).
Y โ YEAR()
Extract year from a date.
Z โ ZONE (AT TIME ZONE)
Convert datetime to specific time zone.
โค๏ธ Double Tap for More
A โ ALTER
Modify an existing table structure (add/modify/drop columns).
B โ BEGIN
Start a transaction block.
C โ CREATE
Create database objects like tables, views, indexes.
D โ DELETE
Remove records from a table.
E โ EXISTS
Check if a subquery returns any rows.
F โ FETCH
Retrieve rows from a cursor.
G โ GRANT
Give privileges to users.
H โ HAVING
Filter aggregated results (used with GROUP BY).
I โ INSERT
Add new records into a table.
J โ JOIN
Combine rows from two or more tables.
K โ KEY (PRIMARY KEY / FOREIGN KEY)
Define constraints for uniqueness and relationships.
L โ LIMIT
Restrict number of rows returned (MySQL/PostgreSQL).
M โ MERGE
Insert/update data conditionally (mainly in SQL Server/Oracle).
N โ NULL
Represents missing or unknown data.
O โ ORDER BY
Sort query results.
P โ PROCEDURE
Stored program in the database.
Q โ QUERY
Request for data (general SQL statement).
R โ ROLLBACK
Undo changes in a transaction.
S โ SELECT
Retrieve data from tables.
T โ TRUNCATE
Remove all records from a table quickly.
U โ UPDATE
Modify existing records.
V โ VIEW
Virtual table based on a query.
W โ WHERE
Filter records based on conditions.
X โ XML PATH
Generate XML output (mainly SQL Server).
Y โ YEAR()
Extract year from a date.
Z โ ZONE (AT TIME ZONE)
Convert datetime to specific time zone.
โค๏ธ Double Tap for More
โค2
๐ ๐๐ถ๐๐ฐ๐ผ ๐๐ฅ๐๐ ๐ง๐ฒ๐ฐ๐ต ๐๐ผ๐๐ฟ๐๐ฒ๐ | ๐ฑ ๐ ๐๐๐-๐๐ผ ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐
Cisco offers learning opportunities covering some of the most valuable foundations for careers in Cybersecurity, Networking, Linux and IoT.
โ Beginner-Friendly Tech Skills
โ Learn In-Demand IT Concepts
โ Build Practical Knowledge
โ Strengthen Your Resume
โ Great for Students & Freshers
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4fhCSKo
๐ฅ Learn from Cisco โข Build Skills โข Upgrade Your Resume โข Get Career-Ready!
Cisco offers learning opportunities covering some of the most valuable foundations for careers in Cybersecurity, Networking, Linux and IoT.
โ Beginner-Friendly Tech Skills
โ Learn In-Demand IT Concepts
โ Build Practical Knowledge
โ Strengthen Your Resume
โ Great for Students & Freshers
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4fhCSKo
๐ฅ Learn from Cisco โข Build Skills โข Upgrade Your Resume โข Get Career-Ready!
โค2
๐ ๐๐๐๐๐ง๐ญ๐ฎ๐ซ๐ ๐
๐๐๐ ๐๐๐ซ๐ญ๐ข๐๐ข๐๐๐ญ๐ข๐จ๐ง ๐๐จ๐ฎ๐ซ๐ฌ๐๐ฌ ๐
Boost your skills with 100% FREE certification courses from Accenture!
๐ FREE Courses Offered:
1๏ธโฃ Data Processing and Visualization
2๏ธโฃ Exploratory Data Analysis
3๏ธโฃ SQL Fundamentals
4๏ธโฃ Python Basics
5๏ธโฃ Acquiring Data
๐๐ข๐ง๐ค ๐:-
https://pdlink.in/4hfxyIX
โ Learn Online | ๐ Get Certified
Boost your skills with 100% FREE certification courses from Accenture!
๐ FREE Courses Offered:
1๏ธโฃ Data Processing and Visualization
2๏ธโฃ Exploratory Data Analysis
3๏ธโฃ SQL Fundamentals
4๏ธโฃ Python Basics
5๏ธโฃ Acquiring Data
๐๐ข๐ง๐ค ๐:-
https://pdlink.in/4hfxyIX
โ Learn Online | ๐ Get Certified
๐ฏ SQL Interview Pattern: Running Total (Cumulative Sum)
Master this one pattern, and you'll be able to solve questions like:
๐ Running Total of Sales
๐ฐ Cumulative Revenue
๐ Customer Lifetime Spend
๐ฆ Running Inventory Balance
๐ฅ Cumulative User Sign-ups
๐ณ Account Balance After Each Transaction
๐ Cumulative Monthly Profit
๐ง How to Identify This Pattern
If the question contains words like:
โข Running Total
โข Cumulative
โข Till Date
โข So Far
โข Progressive Sum
โข Rolling Balance
๐ Think: Window Function (SUM() OVER())
โ Approach
1๏ธโฃ Identify the value to accumulate.
2๏ธโฃ Find the correct ordering column (usually Date or ID).
3๏ธโฃ Use:
SUM(column_name) OVER (
ORDER BY column_name
)
๐ก Bonus Tip:
Need a separate running total for each customer, product, or department?
โก๏ธ Add PARTITION BY before ORDER BY.
โค๏ธ Like this post? React with a โค๏ธ if you'd like more SQL interview patterns!
Master this one pattern, and you'll be able to solve questions like:
๐ Running Total of Sales
๐ฐ Cumulative Revenue
๐ Customer Lifetime Spend
๐ฆ Running Inventory Balance
๐ฅ Cumulative User Sign-ups
๐ณ Account Balance After Each Transaction
๐ Cumulative Monthly Profit
๐ง How to Identify This Pattern
If the question contains words like:
โข Running Total
โข Cumulative
โข Till Date
โข So Far
โข Progressive Sum
โข Rolling Balance
๐ Think: Window Function (SUM() OVER())
โ Approach
1๏ธโฃ Identify the value to accumulate.
2๏ธโฃ Find the correct ordering column (usually Date or ID).
3๏ธโฃ Use:
SUM(column_name) OVER (
ORDER BY column_name
)
๐ก Bonus Tip:
Need a separate running total for each customer, product, or department?
โก๏ธ Add PARTITION BY before ORDER BY.
โค๏ธ Like this post? React with a โค๏ธ if you'd like more SQL interview patterns!
โค2
๐ ๐ ๐ฎ๐๐๐ฒ๐ฟ ๐ฆ๐ค๐ ๐๐ผ๐ฟ ๐๐ฅ๐๐! ๐๏ธ๐ป
Start learning SQL with these 100% FREE resources and build one of the most in-demand skills in tech!
โ Beginner-Friendly SQL Tutorials
โ FREE Online SQL Courses
โ Interactive SQL Practice Platforms
โ Real-World Database Projects
โ Interview Preparation Resources
โ Hands-on Exercises & Challenges
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4yLrNci
๐ Start your SQL journey today and unlock exciting career opportunities!
Start learning SQL with these 100% FREE resources and build one of the most in-demand skills in tech!
โ Beginner-Friendly SQL Tutorials
โ FREE Online SQL Courses
โ Interactive SQL Practice Platforms
โ Real-World Database Projects
โ Interview Preparation Resources
โ Hands-on Exercises & Challenges
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4yLrNci
๐ Start your SQL journey today and unlock exciting career opportunities!
โค1
๐ Complete Roadmap to Become a Power BI Expert
๐ 1. Understand Basics of Data & BI
โ What is Business Intelligence?
โ Importance of data visualization
๐ 2. Learn Power BI Interface
โ Power BI Desktop overview
โ Power Query Editor basics
๐ 3. Connect to Data Sources
โ Excel, SQL Server, SharePoint, APIs, CSV, etc.
๐ 4. Data Transformation & Cleaning
โ Use Power Query to shape, clean, and prepare data
๐ 5. Learn Data Modeling
โ Create relationships between tables
โ Understand star schema & normalization basics
๐ 6. Master DAX (Data Analysis Expressions)
โ Calculated columns, measures, time intelligence functions
๐ 7. Create Interactive Visualizations
โ Charts, slicers, maps, tables, and custom visuals
๐ 8. Build Dashboards & Reports
โ Combine visuals for insightful dashboards
โ Use bookmarks, drill-throughs, tooltips
๐ 9. Publish & Share Reports
โ Power BI Service basics
โ Sharing, workspaces, and app creation
๐ 10. Learn Power BI Administration
โ Row-level security (RLS)
โ Gateway setup & scheduled refresh
๐ 11. Practice Real-World Projects
โ Sales dashboards, financial reports, customer insights
๐ Like for more!
๐ 1. Understand Basics of Data & BI
โ What is Business Intelligence?
โ Importance of data visualization
๐ 2. Learn Power BI Interface
โ Power BI Desktop overview
โ Power Query Editor basics
๐ 3. Connect to Data Sources
โ Excel, SQL Server, SharePoint, APIs, CSV, etc.
๐ 4. Data Transformation & Cleaning
โ Use Power Query to shape, clean, and prepare data
๐ 5. Learn Data Modeling
โ Create relationships between tables
โ Understand star schema & normalization basics
๐ 6. Master DAX (Data Analysis Expressions)
โ Calculated columns, measures, time intelligence functions
๐ 7. Create Interactive Visualizations
โ Charts, slicers, maps, tables, and custom visuals
๐ 8. Build Dashboards & Reports
โ Combine visuals for insightful dashboards
โ Use bookmarks, drill-throughs, tooltips
๐ 9. Publish & Share Reports
โ Power BI Service basics
โ Sharing, workspaces, and app creation
๐ 10. Learn Power BI Administration
โ Row-level security (RLS)
โ Gateway setup & scheduled refresh
๐ 11. Practice Real-World Projects
โ Sales dashboards, financial reports, customer insights
๐ Like for more!
โค2