SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- Create the table
CREATE TABLE df (
    country VARCHAR(50),
    year INT,
    val1 INT,
    val2 INT,
    val3 INT
);

-- Insert 10 rows of data
INSERT INTO df (country, year, val1, val2, val3) VALUES
('USA', 2020, 4, 4, 5),
  ('USA', 2020, 4, 4, 5),
  ('USA', 2020, 5, 5, 5),
  ('USA', 2020, 5, 5, 5),
  ('USA', 2020, 1, 1, 5),
  ('USA', 2020, 3, 3, 5),
  ('USA', 2020, 4, 2, 5),
  ('USA', 2020, 1, 1, 5),
  ('USA', 2020, 2, 2, 5),
  ('Canada', 2020, 1, 1, 3),
  ('Canada', 2020, 2, 2, 3),
  ('Canada', 2020, 4, 4, 3),
  ('Canada', 2020, 3, 4, 3),
  ('Canada', 2020, 3, 4, 3),
  ('Canada', 2020, 3, 4, 3),
  ('Canada', 2020, 5, 4, 3),
  ('Canada', 2020, 5, 4, 5),
  ('Canada', 2020, 5, 4, 5),
('Germany', 2022, 5, 5, 4),
('France', 2020, 1,1, 2),
  ('France', 2020, 1,1, 2),
  ('France', 2020, 3, 2, 2),
  ('France', 2020, 3, 4, 2),
  ('France', 2020, 3, 5, 5),
  ('France', 2020, 3, 4, 4),
  ('France', 2020, 3, 4, 4),
  ('France', 2020, 3, 4, 3),
('UK', 2021, 4, 2, 3),
('Australia', 2022, 3, 3, 4),
('Italy', 2020, 5, 5, 5),
  ('Italy', 2020, 5, 5, 5),
  ('Italy', 2020, 5, 1,1),
   ('Italy', 2020, 4, 4,1),
   ('Italy', 2020, 2, 1,2),
  ('Italy', 2020, 3, 5, 3),
('Spain', 2021, 1, 2, 3),
('Mexico', 2022, 4, 4, 4),
    ('Brazil', 2020, 4, 1, 1),
  ('Brazil', 2020, 4, 1, 1),
  ('Brazil', 2020, 4, 3, 4),
  ('Brazil', 2020, 5, 3, 5),
    ('Brazil', 2020, 5, 3, 5),
  ('Brazil', 2020, 3, 3, 1),
('Brazil', 2020, 2, 3, 1);
-- Add the mode column to the table
select * from df;

country	year	val1	val2	val3
USA	2020	4	4	5
USA	2020	4	4	5
USA	2020	5	5	5
USA	2020	5	5	5
USA	2020	1	1	5
USA	2020	3	3	5
USA	2020	4	2	5
USA	2020	1	1	5
USA	2020	2	2	5
Canada	2020	1	1	3
Canada	2020	2	2	3
Canada	2020	4	4	3
Canada	2020	3	4	3
Canada	2020	3	4	3
Canada	2020	3	4	3
Canada	2020	5	4	3
Canada	2020	5	4	5
Canada	2020	5	4	5
Germany	2022	5	5	4
France	2020	1	1	2
France	2020	1	1	2
France	2020	3	2	2
France	2020	3	4	2
France	2020	3	5	5
France	2020	3	4	4
France	2020	3	4	4
France	2020	3	4	3
UK	2021	4	2	3
Australia	2022	3	3	4
Italy	2020	5	5	5
Italy	2020	5	5	5
Italy	2020	5	1	1
Italy	2020	4	4	1
Italy	2020	2	1	2
Italy	2020	3	5	3
Spain	2021	1	2	3
Mexico	2022	4	4	4
Brazil	2020	4	1	1
Brazil	2020	4	1	1
Brazil	2020	4	3	4
Brazil	2020	5	3	5
Brazil	2020	5	3	5
Brazil	2020	3	3	1
Brazil	2020	2	3	1

country	Very Dissatisfied	Dissatisfied	Neutral	Satisfied	Very Satisfied	Count
Brazil	0.285714285714	0.142857142857	0.142857142857	0.142857142857	0.285714285714	7
Canada	0.111111111111	0.111111111111	0.333333333333	0.222222222222	0.222222222222	9
France	0.250000000000	0.125000000000	0.250000000000	0.250000000000	0.125000000000	8
Italy	0.166666666666	0.166666666666	0.166666666666	0.166666666666	0.333333333333	6
USA	0.222222222222	0.111111111111	0.111111111111	0.333333333333	0.222222222222	9

Warning: Null value is eliminated by an aggregate or other SET operation.