Skip to content

Instantly share code, notes, and snippets.

@HenryAtWealthfront

HenryAtWealthfront/better_query1.sql

Created May 23, 2023 21:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save HenryAtWealthfront/b8e182a73dc6d9745bde3dccab4bf0a4 to your computer and use it in GitHub Desktop.
Save HenryAtWealthfront/b8e182a73dc6d9745bde3dccab4bf0a4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
better_query1.sql
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())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment