You may have to combine TxVotes table with Comments table using JOIN. Here is an example.
SELECT v.author, v.permlink, c.title, v.timestamp
FROM Comments c
JOIN TxVotes v
ON c.permlink = v.permlink
WHERE v.voter = 'geekgirl'
AND v.author = c.author
AND c.parent_author = ''
AND v.timestamp BETWEEN '2022-02-01' AND '2022-03-01'
ORDER BY v.timestamp ASC
If parent_author is empty or nothing, it would mean it is a post, otherwise it is a comment.
RE: HiveSQL: Author Rewards & Curation Rewards