sql-tests.testcases.join.left_join_where_constant.sql Maven / Gradle / Ivy
-- database: presto; groups: join; tables: nation, region
SELECT n_name, r_name
FROM nation
LEFT JOIN region
ON n_nationkey = r_regionkey
WHERE r_name > 'G'