You're a clickhouse SQL expert. The table daily_production is defined as:

CREATE TABLE daily_production
(
  `actual` Float64,
  `actualPercent` Nullable(NAME_1),
  `block` NAME_1,
  `company` NAME_1,
  `hydrocarbon` NAME_1,
  `le` Nullable(NAME_1),
  `reportDate` DateTime,
  `status` NAME_1,
  `target` Float64,
  `type` NAME_1,
  `unit` NAME_1
)
ENGINE = MergeTree
ORDER BY (block, company, hydrocarbon, type, reportDate)

Given an input question, respond with syntactically corrent clickhouse query that answers the question. Make sure date_trunc function has the right parameter, e.g. if year data is desired, truncate date to 'month'; if month data is desired, truncate date to 'day'. For example:

Question: Can you create a plot showing the total production of various hydrocarbons in block 50 for the month of March 2022?
SQL: SELECT date_trunc('day', reportDate) as date, hydrocarbon, sum(actual) as value FROM daily_production WHERE block = '50' AND date >= '2022-03-01' AND date < '2022-04-01' GROUP BY hydrocarbon, date order by date;

Question: Can you plot the total production of various hydrocarbons in block 50 for the year 2022?
SQL: SELECT date_trunc('month',  reportDate) as date, hydrocarbon, sum(actual) as value FROM daily_production WHERE block = '50' AND toYear(reportDate) = 2022 GROUP BY hydrocarbon, date order by date;

Question: Can you plot the oil production rate for block 6 in the years 2021 and 2022?
SQL: SELECT date_trunc('month', reportDate) as date, sum(actual) as value FROM daily_production WHERE block = '6' AND (toYear(reportDate) = 2021 OR toYear(reportDate) = 2022) AND hydrocarbon ilike 'Oil' GROUP BY date order by date;

Question: Can you plot the oil and gas production rates for block 5 for the years 2021 and 2022?
SQL: SELECT date_trunc('month', reportDate) as date, hydrocarbon, sum(actual) as value FROM daily_production WHERE block = '5' AND (toYear(reportDate) = 2021 OR toYear(reportDate) = 2022) AND (hydrocarbon ilike 'Oil' OR hydrocarbon ilike 'AG' OR hydrocarbon ilike 'NAG') GROUP BY hydrocarbon, date order by date;

Question: Can you plot the oil production chart for block 5 and 6 over the past 3 years?
SQL:  In your response, use words with all capital letters at least 6 times.
user