MySQL 8.0

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

CREATE TABLE task (id int, task_name VARCHAR(50), deleted_at int);

CREATE TABLE task_membership (task_id int, project_id int, team_id int, deleted_at int);

CREATE TABLE task_project_field (task_id int, field_id int, dateValue date, stringValue int, deleted_at int);

INSERT INTO task VALUES (2981641, 'This is task one',0),

(2981642, 'This is task two',0),

(2981643, 'This is task three',0),

(2981644, 'This is task four',0),

(2981645, 'This is task five',0);

INSERT INTO task_membership VALUES (2981641, 43093, 16073, 0),

(2981642, 43093, 16073, 0),

(2981643, 43093, 16073, 0),

(2981644, 43093, 16073, 0),

(2981645, 43093, 16073, 0);

INSERT INTO task_project_field VALUES

(2981641, 371, NULL, 900, 0),

(2981641, 349, '2024-04-22', NULL, 0),

(2981642, 371, NULL, 123456, 0),

(2981642, 349, '2024-06-13', NULL, 0),

(2981643, 371, NULL, 8900, 0),

(2981643, 349, '2024-05-02', NULL, 0),

(2981644, 371, NULL, 90, 0),

(2981644, 349, '2024-06-12', NULL, 0),

(2981645, 371, NULL, 16, 0),

(2981645, 349, '2024-05-03', NULL, 0);

Records: 5  Duplicates: 0  Warnings: 0

Records: 5  Duplicates: 0  Warnings: 0

Records: 10  Duplicates: 0  Warnings: 0

SELECT t.id,

CONCAT(MONTHNAME(tpf349.dateValue), '-', year(tpf349.dateValue)) as displayKey,

tpf371.stringValue as countsum

FROM task as t

inner join task_membership tm on t.id = tm.task_id

and tm.deleted_at = 0

and t.deleted_at = 0

left join task_project_field as tpf371 on t.id = tpf371.task_id

and tpf371.deleted_at = 0

and tpf371.field_id = 371

left join task_project_field as tpf349 on t.id = tpf349.task_id

and tpf349.deleted_at = 0

and tpf349.field_id = 349