sql query format in python

PHOTO EMBED

Thu Nov 25 2021 14:40:12 GMT+0000 (UTC)

Saved by @adamyalei #python #mysql

    if year < 2020 and not (year == 2019 and quarter == 4):
        query_churn = "SELECT sum(eur) FROM salesforce_summaries WHERE (\"Type of Business\" = 'Churn' AND \"Import from Weekly KPI Excel\" = 'True') AND time >= '{quarter_start}' AND time <= '{quarter_end}'".format(
            quarter_start=quarter_start, quarter_end=quarter_end)
content_copyCOPY

https://gitlab.hornetsecurity.com/search?group_id