The below Query Display Number of 'a' either it is upper case or lower case.
select first_name,length(first_name)-length(replace(lower(first_name), 'a')) from employees;
Count The Number of 'A'
select first_name,length(first_name)-length(replace(first_name, 'A')) from employees;&nbs...
