if object_id (N'TempDB..#BLexception') is not NULL drop table #BLexception

create table #BLexception
(bith_data varchar(1000), lastName varchar(1000), firstName varchar(1000), middleName varchar(1000))
insert into #BLexception
values
(('06-21-1993'),('Денис'),('Зайцев'),('Дмитриевич')),
(('07-15-1992'),('Анна'),('Тутова'),('Владимировна'));
 


 select appl_month, count(id)as 'кол-во заявок'
 from bwk as mt 
left join #BLexception as bl
on bl.bith_data=mt.birth_date and bl.firstName=mt.first_name and bl.lastName=mt.last_name and bl.middleName=mt.middle_name
group by appl_month