desktop = '''
         select
             sum(total_revenue) as all_total_revenue,
             max(total_revenue) - min(total_revenue) as delta_max_min
         from
         (select
             o.uid,
             sum(o.revenue) as total_revenue
         from
             orders o
         inner join visits v on v.uid = o.uid and v.device = 'desktop' and o.buyts >= v.startts and o.buyts <= v.endts
         group by
             o.uid
         ) as moo
         '''

select(desktop)