SELECT
ad_group_simulation.start_date,
ad_group_simulation.end_date,
ad_group_simulation.ad_group_id,
ad_group.campaign,
ad_group_simulation.modification_method,
ad_group_simulation.resource_name,
ad_group_simulation.target_cpa_point_list.points
FROM ad_group_simulation
WHERE
ad_group_simulation.start_date = '2021-11-14' AND
ad_group_simulation.end_date = '2021-11-16' AND
ad_group_simulation.type = TARGET_CPA