SELECT
    sad.stat_term,
    SUM(sad.stat_enters) as enters,
    SUM(sad.stat_hits) as hits,
    ROUND(SUM(`stat_enters`*`src_coef`)) as `clicks`,
    ROUND(SUM(`stat_teas`) / SUM(sad.stat_enters), 2) as percent_clicks,
    SUM(`stat_teas`) as `teaser_views`,
    SUM(`stat_teased`) as `teaser_clicks`,
    ROUND(SUM(sc.`src_per`* sad.`stat_enters`)) as costs,
    SUM(sad.stat_orders_profit) as profit
FROM `stat_A_days` as sad
LEFT JOIN stat_cost as sc ON sc.src_date = sad.stat_date AND sc.src_name = sad.stat_source
WHERE sad.`stat_date` > '2017-12-01' AND sad.stat_source = 'marketgid'
GROUP BY sad.`stat_term`
HAVING SUM(sad.stat_enters) >= 200 AND ROUND(SUM(`stat_teas`) / SUM(sad.stat_enters), 2) <= 10
ORDER BY NULL