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 |