SQL 代码规范样式示例
这里有一个完整的查询，向你展现该样式指引在实践中是什么样子：
with hubspot_interest as (
select
email,
timestamp_millis(property_beacon_interest) as expressed_interest_at
from hubspot.contact
where property_beacon_interest is not null
),
support_interest as (
select
conversation.email,
conversation.created_at as expressed_interest_at
from helpscout.conversation
inner join helpscout.conversation_tag on conversation.id = conversation_tag.conversation_id
where conversation_tag.tag = 'beacon-interest'
),
combined_interest as (
select * from hubspot_interest
union all
select * from support_interest
),
final as (
select
email,
min(expressed_interest_at) as expressed_interest_at
from combined_interest
group by email
)
select * from final
关于 LearnKu
粤公网安备 44030502004330号