Flutterist

select u.name user_name, 
	     u.phone user_phone, 
	     sum(o.subtotal) orders_sum, 
	     avg(o.subtotal) orders_avg,
	     MAX(o.created) last_order_created
  from users u
  inner join orders o on o.user_id = u.id
  group by u.name, u.phone