How to get all abandoned checkouts from checkout table?
If you want to know if a checkout was completed, you would look at the completed_at field. This will be a timestamp of when the checkout became an order. All the abandoned checkouts have completed_at field as null.
SELECT * FROM shopify.checkout WHERE completed_at is NULL;