Postgres 11

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

CREATE TABLE books( id INT, bookstore_id INT,result JSONB );
INSERT INTO books  
VALUES(1, 3,'[{"name":"$.publishedMonth", "value":"04"},
              {"name":"$.publishedYear","value":"1972"},
              {"name":"$.publishedEmail","value":"Ina@yahoo.com"}]'::jsonb),
      (2, 3,'[{"name":"$.publishedMonth", "value":"07"},
              {"name":"$.publishedYear","value":"2020"},
              {"name":"$.publishedEmail","value":"Ina@google.com"}]'::jsonb);
2 rows affected

SELECT id, STRING_AGG(j ->> 'value', '-' ORDER BY j ->> 'name') AS "publishedMonthYear"
  FROM books,
       JSONB_ARRAY_ELEMENTS(result) AS arr(j)
 WHERE bookstore_id = 3
   AND j ->> 'name' IN ('$.publishedMonth','$.publishedYear')
 GROUP BY id 


id
publishedMonthYear


1
04-1972

2
07-2020