select u.user_id buyer_id,join_date,ifnull(t.cnt,0) orders_in_2019 from
Users u left join
(select buyer_id,count(order_date) cnt from Orders
where order_date between '2019-01-01' and '2019-12-31'
group by buyer_id) t
on u.user_id = t.buyer_id
select u.user_id buyer_id,join_date,ifnull(t.cnt,0) orders_in_2019 from
Users u left join
(select buyer_id,count(order_date) cnt from Orders
where order_date between '2019-01-01' and '2019-12-31'
group by buyer_id) t
on u.user_id = t.buyer_id