SQL Query To Find Most Known Skills | Find Most Repeated Skills Data Analyst SQL Interview Problems

In this video we will see one of the asked SQL interview problems and answers for data analyst. In this SQL interview task we will use group by, having clause & count function with distinct clause of sql server.
=========================================
This video solves below queries.
=========================================
1. Data analyst interview questions and answers.
2. SQL server interview question and answers.
3. SQL sever group by and having clause.
4. Data analyst intern interview questions.
5. Data science analyst interview questions.
6. Data analyst interview preparation.
7. Data analyst interview questions.
8. Data analyst interview.
=========================================
Take a look, You may find below vides interesting.
=========================================
Find loyal customers of online food delivery app.
• Data Analyst SQL Inter...
Most tricky sql interview problem
• SQL Problem I Failed T...
How to get list of all table & their record count.
• How To Get Record Coun...
SQL query to calculate account balance sheet.
• Accenture SQL Intervie...
=========================================
Table DDL & Insert Statement for Practice
=========================================
CREATE TABLE DBO.TBL_SKILLS
(
STUD_NAME VARCHAR(50) NOT NULL,
STUD_SKILL VARCHAR(255) NOT NULL
);
GO
INSERT INTO DBO.TBL_SKILLS(STUD_NAME,STUD_SKILL)VALUES
('Sam','ADF'),
('Sam','ADB'),
('Sam','SQL'),
('Sam','Python'),
('Tom','Power BI'),
('Tom','Excel'),
('Tom','SQL'),
('Mike','C#'),
('Mike','Java'),
('Jan','Java'),
('Mike','ADF'),
('Mike','SQL');
GO
SELECT * FROM DBO.TBL_SKILLS;
GO
--Solution query
SELECT
TOP 1 STUD_SKILL
FROM DBO.TBL_SKILLS
GROUP BY STUD_SKILL
ORDER BY COUNT(STUD_SKILL) DESC;
--==========================================
#bitechlake #bizzintelligence

[@AnkitDasCo]

I think this will miss an edge case where multiple skills are most known

[@BITechLake]

Yes definitely. In that case either dense rank or sun query.
But I appreciate your finding.