根据这三个语句反推其中包含的表结构：
select "gate_records"."gate_id" ,sum(gate_records.volume) as volume from "gate_records" where "gate_records"."deleted_at" is null and gate_id in(
select id from "gates" where "gates"."deleted_at" is null and "gates"."setup_land_region_id" in (
select id from "land_regions" where "land_regions"."deleted_at" is null and "land_regions"."parent_id" = 2
)
) group by "gate_records"."gate_id";
select id, name, lat_long
from "gates"
where "gates"."deleted_at" is null
and "gates"."setup_land_region_id" in (select id
from "land_regions"
where "land_regions"."deleted_at" is null
and "land_regions"."parent_id" = 2);
select gate_records.gate_id, sum(gate_records.volume) as volume, gates.name as name, gates.lat_long as lat_long
from gate_records
join gates on gate_records.gate_id = gates.id
where gate_records.deleted_at is null
and gates.deleted_at is null
and gate_id in (select id
from "gates"
where "gates"."deleted_at" is null
and "gates"."setup_land_region_id" in (select id
from "land_regions"
where "land_regions"."deleted_at" is null
and "land_regions"."parent_id" = 2))
group by gate_records.gate_id, gates.name, gates.lat_long;
这三个语句涉及了三个表：gate_records、gates 和 land_regions。
gate_records表包含字段：
gate_id
volume
deleted_at
gates表包含字段：
id
name
lat_long
deleted_at
setup_land_region_id
land_regions表包含字段：
id
parent_id
deleted_at
第一个查询是关于gate_records表和与其相关联的gates和land_regions表的聚合查询。它选择了gate_records表中的gate_id和volume字段，并对volume字段进行了求和。条件是gate_records表中deleted_at为空，并且gate_id存在于满足一定条件的gates表中。该条件是gates表中deleted_at为空，并且setup_land_region_id存在于满足一定条件的land_regions表中（这些条件包括deleted_at为空并且parent_id为2）。
第二个查询选择了gates表中的id、name和lat_long字段，条件是gates表中deleted_at为空，并且setup_land_region_id存在于满足一定条件的land_regions表中（这些条件包括deleted_at为空并且parent_id为2）。
第三个查询是一个联合查询，涉及gate_records和gates表。它选择了gate_records表中的gate_id和volume字段的求和，并将gates表中的name和lat_long字段也加入了结果集。条件包括了gate_records和gates表中的deleted_at为空，并且gate_id存在于满足一定条件的gates表中。这些条件类似于前两个查询中的条件，都是关于gates表中deleted_at为空，并且setup_land_region_id存在于满足一定条件的land_regions表中（这些条件包括deleted_at为空并且parent_id为2）。
