mysql statement writing

Question

A table has six fields ABCDEF. The requirement is to find out whether ABCD is consistent and merge it into one, and count how many different E's there are in the merged entries.
In other words, abcd is the same as one piece of data. Then abcd the same multiple pieces of data to e to deduplicate, the result is probably like this
ABCD2
How to write such a sql statement

Answer 1

select a,b,c,d,count(distinct(e)) from t group by a,b,c,d

Answer 2

select *,count(distinct A) from table group by A,B,C,D;

Try it.