31. Total Employees in Each Department | Crack GOOGLE AMAZON APPLE | SQL Interview Question | Easy

🚀 Today, we will solve an easy SQL interview question by Google.

🔓 Crack SQL rounds for Data Scientist, Data Analyst, Machine Learning Engineer, Data Engineer, and Web Development jobs with our playlist of MySQL Interview Questions.

🔧 Difficulty level: Easy 🟢
🔗 Practice on StrataScratch: https://bitly.cx/iFhAj

⚡Solution:
```
SELECT
department AS department_name,
COUNT(worker_id) AS number_of_employees
FROM worker
GROUP BY (department)
```

💡 Share & Subscribe for more: @kantcodes
➡️ SQL Interview Questions Playlist:    • SQL Interview Questions Explained - Crack ...  
📝 Leave your queries & feedback in the comments below.

🧔🏻‍♂️ Connect with me:
Website: https://kantschants.com/
Blog:   / utkarsh.kant  
LinkedIn:   / utkarsh-kant  
Github: https://github.com/utkarshkant


#sql #interview #sqlinterview #sqlinterviewquestionsandanswers #faang #tech #tutorial #guide #datascience #machinelearning #dataengineers #ai #webdevelopment #softwaredeveloper #database