I need two columns from a table & I need one computed column of count() Ex: Employee table
This is the table. I need the result 3 columns. These 2 columns & third computed column consists of no. of e. Answer should be like below
How can I write T-SQL query for this. Thanks.