Untitled

Sum on a left join SQL
select a.*, sum(b.ach_sell) from bookings a
left join pricing_line b on b.bookings = a.id

select a.id, sum(b.ach_sell)
from bookings a
  left join pricing_line b
on b.bookings = a.id
group by a.id

select a.this, a.that, sum(b.ach_sell)
from bookings a
left join pricing_line b on b.bookings = a.id
group by a.this, a.that

select a.*,
       sum(b.ach_sell) as ach_sell
from bookings a
left join pricing_line b on b.bookings = a.id
GROUP BY  a.id

select a.*, sum(b.ach_sell) as sum_column
from bookings a
  left join pricing_line b
         on b.bookings = a.id
group by a.id