By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE pracownicy (nazwisko) AS
SELECT 'Alice' FROM DUAL UNION ALL
SELECT 'Beryl' FROM DUAL UNION ALL
SELECT 'Carol' FROM DUAL UNION ALL
SELECT 'Debra' FROM DUAL UNION ALL
SELECT 'Emily' FROM DUAL UNION ALL
SELECT 'Fiona' FROM DUAL UNION ALL
SELECT 'Glory' FROM DUAL UNION ALL
SELECT 'Heidi' FROM DUAL UNION ALL
SELECT 'Irene' FROM DUAL;
9 rows affected
SELECT COUNT(CASE WHEN LOWER(nazwisko) LIKE '%a%' THEN 1 END) as "Ile nazwisk z A",
COUNT(CASE WHEN LOWER(nazwisko) LIKE '%e%' THEN 1 END) as "Ile nazwisk z E"
FROM pracownicy
| Ile nazwisk z A | Ile nazwisk z E |
|---|---|
| 4 | 6 |