SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Customer(id_customer INTEGER);
INSERT INTO Customer(id_customer) VALUES
  ('1234');
1 rows affected

CREATE TABLE Profile (id_profile INTEGER, nm_profile VARCHAR(12));
INSERT INTO Profile (id_profile, nm_profile) VALUES
  ('1234', 'User profile');
1 rows affected

CREATE TABLE Orders (id_order INTEGER, id_customer INTEGER, order_date DATE, order_type VARCHAR(6));
INSERT INTO Orders (id_order, id_customer, order_date, order_type) VALUES
  ('10308', '1234', '2017-09-18', 'Online'),
  ('10309', '1234', '2018-09-18', 'Online');
2 rows affected

CREATE TABLE Reviews (id_reviewer INTEGER, id_profile INTEGER, text VARCHAR(12), score INTEGER);
SELECT t.id_customer, t.order_date, r.text review_text
FROM ( 
  SELECT c.id_customer, MIN(o.order_date) order_date
  FROM Customer c
  INNER JOIN Profile p ON c.id_customer = p.id_profile 
  LEFT JOIN Orders o ON o.id_customer = c.id_customer AND o.order_type = 'Online'
  WHERE c.id_customer = 1234
  GROUP BY c.id_customer
) t
LEFT JOIN Reviews r ON r.id_reviewer = t.id_customer AND r.score = 5


id_customer
order_date
review_text


1234
2017-09-18
null