I need query for three table with join

Question

Dear all,

 

Kindly find below table records for sample data.

 

TABLE-01
Dept	Total No of codes
A	1191
B	1039
C	2012
D	3780
E	9
F	5972
G	2186
TABLE-02
user	dept
U1	A
U2	A
U3	B
U4	C
U5	E
U6	G
TABLE-03
USER	VAL1	date
U1	1001	06-10-2020
U2	1002	06-10-2020
U4	1004	06-10-2020
U3	1003	07-10-2020
U4	1005	07-10-2020
U4	1004	07-10-2020
U4	1006	08-10-2020
U5	1005	08-10-2020
U3	1003	09-10-2020
U6	1006	09-10-2020

 
An I need result as below:

Result
Dept	Total No of codes	Total CompletedCodes	06-10-2020	07-10-2020	08-10-2020	09-10-2020
A	10	2	2	0	0	0
B	20	2	0	1	0	1
C	15	4	1	2	1	0
D	30	0	0	0	0	0
E	9	1	0	0	1	0
F	44	0	0	0	0	0
G	58	1	0	0	0	1
total	186	10	3	3	2	2

Please find below image for your ref.