SQL Interview question: Calculate Percentage Analysis by Department #sql #dataanalyst #sqlinterview

In this video, we solve an important SQL interview question: How to calculate the percentage of active employees in each department compared to the total number of active and inactive employees in the company. You will learn: How to filter active employees in SQL How to calculate department-wise counts How to compute percentage using SQL aggregation functions How to write a simple and optimized SQL query This example is useful for: SQL beginners Interview preparation Data analysis and reporting scenarios 📌 Topics Covered: COUNT() GROUP BY CASE WHEN Percentage calculation in SQL If you’re preparing for SQL interviews or working with employee data, this video will help you understand the concept clearly. #sqlinterview #sqlinterviewquestionsandanswers #sqlinhindi