SQL Server 2017 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t (
  "Id" INTEGER,
  "FKId" INTEGER,
  "TypeId" INTEGER,
  "Score" INTEGER,
  "ScoreDate" date
);

INSERT INTO t
  ("Id", "FKId", "TypeId", "Score", "ScoreDate")
VALUES
  ('1', '317', '1', '90', '2019-01-01'),
  ('2', '317', '1', '80', '2019-01-02'),
  ('3', '317', '2', '65', '2019-01-03'),
  ('4', '317', '2', '80', '2019-01-04'),
  ('5', '318', '1', '82', '2019-01-01'),
  ('6', '318', '1', '78', '2019-01-02'),
  ('7', '318', '2', '55', '2019-01-03'),
  ('8', '318', '2', '63', '2019-01-04');
8 rows affected

select [FkId], max([1]) as c1, max([2]) as c2, max([3]) as c3, max([4]) as c4 from
(
select FkId, [1], [2], [3], [4] from
(
  select *
  from
  (
    select [FkId], [TypeId], [Score]
    from t
  ) src
  pivot
  (
    max([Score])
    for [TypeId] in ([1], [2] , [3], [4])
  ) as Piv1
) P
union all
select FkId, null, null, [1], [2] from
(
  select *
  from
  (
    select [FkId], [TypeId], [Score]
    from t
  ) src
  pivot
  (
    min([Score])
    for [TypeId] in ( [1], [2])
  ) as Piv2
) P2
) PP
group by FkId


FkId
c1
c2
c3
c4


317
90
80
80
65

318
82
63
78
55


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