HenryAtWealthfront

SELECT
   * 
FROM
   orders 
   JOIN
      order_allocations 
      ON orders.id = order_allocations.order_id 
WHERE
   orders.completed_at > date(now()) 
   AND order_allocations.client_id = 'A' 

HenryAtWealthfront

SELECT
   id 
FROM
   orders 
WHERE
   completed_at BETWEEN date_sub(date(now()), INTERVAL 1 day) AND date(now())

HenryAtWealthfront

SELECT
   * 
FROM
   orders 
   JOIN
      order_allocations 
      ON orders.id = order_allocations.order_id 
WHERE
   order_allocations.client_id = 'A' 
   AND order_allocations.completed_at > date(now())

HenryAtWealthfront

SELECT
   * 
FROM
   orders 
   JOIN
      order_allocations 
      ON orders.id = order_allocations.order_id 
WHERE
   order_allocations.client_id = 'A' 
   AND orders.completed_at > date(now())