A. select count(distinct name) from student_table;

B. select count(name) from (select distinct name from student_table) t1;

C. select count(name) from (select name,count(*) as c1 from student_table group by name having c1 >1 ) t1;

D. select count(name) from (select name from student_table group by name) t1;