By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table
wa_fn_usec_hr_employee_attrition_tsv(
attrition varchar(10),
businesstravel varchar(50));
insert into
wa_fn_usec_hr_employee_attrition_tsv
values
('Yes','Travel_Rarely'),
('No','Travel_Frequently'),
('Yes','Travel_Rarely'),
('No','Travel_Frequently'),
('No','Travel_Rarely');
SELECT
businesstravel,
attrition,
COUNT(*)
FROM wa_fn_usec_hr_employee_attrition_tsv
GROUP BY
businesstravel,
attrition;
| businesstravel | attrition | COUNT(*) |
|---|---|---|
| Travel_Rarely | Yes | 2 |
| Travel_Frequently | No | 2 |
| Travel_Rarely | No | 1 |