知识点

• WHERE LIKE
• WHERE/HAVING
• OVER()
• LATERAL VIEW
• GROUP BY 1, 2, 3
• collect_list/set()
• WHERE-True/False
• IS/= NULL
• regexp_extract()
• WITH (CTE)