查询对话的点赞

select COALESCE(like_rating.id, dislike_rating.id) AS conversation_id, COALESCE(like_rating, 0) as like_rating, COALESCE(dislike_rating, 0) as dislike_rating
    from (

          (select c.id, count(*) as like_rating
            from conversations c
                     left join
                 message_feedbacks mf
                 on c.id = mf.conversation_id
            where c.app_id = '58663dd9-6354-4968-a0e3-c12017dafda8'
            and rating = 'like'
            group by c.id, rating) as like_rating
    full outer join
    (select c.id, count(*) as dislike_rating
    from conversations c
             left join
         message_feedbacks mf
         on c.id = mf.conversation_id
    where c.app_id = '58663dd9-6354-4968-a0e3-c12017dafda8'
    and rating = 'dislike'
    group by c.id, rating) as dislike_rating
    on like_rating.id = dislike_rating.id)