SQL Interview Question | SQL Intermediate Question

Question - Write an SQL query 𝐭𝐨 𝐟𝐢𝐧𝐝 𝐭𝐡𝐞 𝐜𝐨𝐮𝐧𝐭 𝐨𝐟 𝐝𝐢𝐬𝐭𝐢𝐧𝐜𝐭 𝐝𝐞𝐩𝐚𝐫𝐭𝐦𝐞𝐧𝐭𝐬 𝐢𝐧𝐜𝐥𝐮𝐝𝐢𝐧𝐠 𝐍𝐔𝐋𝐋.
drop table department
create table department(deptid int, deptname varchar(50));
insert into department values(1,'Tech');
insert into department values(2,'HR');
insert into department values(3,null);
insert into department values(4,'Tech');
insert into department values(5,'HR');
select * from department;
#dataanalytics #sqldeveloper #amazon #facebook #flipkart #placement