create table t1 (
    val1 varchar(50),)

select count(*) from t1
where val1 like 'abc'
group by val1