"""Select Project names form SME label copy table."""

SELECT_PROJECT_NAME_FROM_SME_LABELCOPY_BY_UPC = """
    SELECT DISTINCT sl.prod_no as product_code, pm.project_no, pm.project_title as project_name
        FROM {snowflake_db}.{snowflake_schema}.{snowflake_table} sl
        INNER JOIN {snowflake_sony_db}.{snowflake_sony_schema}.{snowflake_sony_table} pm
            ON sl.prod_no = pm.product_no
        WHERE sl.prod_no IN ({product_code_list})
"""  # noqa