Most Common SQL Interview Question for Data Analyst | SQL Interview Problem And Answers

In this video we will see one more sql interview problems and answers for data analyst. We will write sql query to get the male and female employee count per department. This is one of the most common sql interview task asked to data analyst to solve. As a data analyst you must be prepared and must have solved all common sql problems that are asked in data analyst interviews.
=========================================
This video solves below queries.
1. SQL server case statement.
2. SQL server group by clause.
3. Data analyst sql interview problems and answers.
4. Aggregation functions in sql server.
5. sql server interview questions and answers.
6. sql query to get male and female count per department.
=========================================
Take a look, You may find below vides interesting.
1. Accenture SQL interview problem for data analyst.
https://youtu.be/4TLmvy7lR10?si=N35RaZuGOXWX-sMJ
2. How to combine multiple rows into single row in sql server
https://youtu.be/g-bLekv2kjU?si=kZHKcipnv-8yxehe
3. SQL Task to get missing month name & salary.
https://youtu.be/Y-d_5Yqi7I0?si=yjWxEyYUxLM98_1G
4. Most asked sql interview question for data analyst.
https://youtu.be/8T2MgbQxQcw?si=ODUeCIDIucvkr5VA
5. SQL task that i FAILED to solve initially as a data analyst.
https://youtu.be/0jrbUuDsWjI?si=pyh2fRKJ0Jk-xaLl
6. Find loyal customers of online food delivery app.
https://youtu.be/TWUqE7pk6n4?si=dORtL8htjI33HqMP
=========================================
Table DDL, Insert statement & solution queries for practice.
=========================================
CREATE TABLE DBO.EMP_DETAILS
(
EMP_NAME VARCHAR(50) NOT NULL,
EMP_DEPT SMALLINT NOT NULL,
EMP_GENDER VARCHAR(10) NOT NULL,
EMP_SAL INT NOT NULL
);
INSERT INTO DBO.EMP_DETAILS(EMP_NAME,EMP_GENDER,EMP_SAL,EMP_DEPT) VALUES
('Rohit','Male',10000,1000),
('Anushka','Female',30000,1000),
('Sam','Male',10000,1000),
('Vijay','Male',10000,2000),
('Deepika','Female',10000,2000),
('Shruti','Female',10000,1000),
('Sania','Female',10000,1000);
go
SELECT
E.EMP_DEPT,
SUM(IIF(E.EMP_GENDER='Male',1,0)) AS Male_Count,
SUM(IIF(E.EMP_GENDER='Female',1,0))AS Female_Count
FROM DBO.EMP_DETAILS E
GROUP BY E.EMP_DEPT;
=========================================
#bitechlake #bizzintelligence