Report not found

There was a problem finding this report.

Report

Accounts table

Customers w/o order

Orders table

Customers without August 2016 order
September 22, 2016 · Refreshed over 2 years ago

Collaborators

Run History
SELECT * FROM demo.orders
SELECT * FROM demo.orders
SELECT * FROM demo.accounts
SELECT * FROM demo.accounts
SELECT a.id as customer_id, a.name as customer_name FROM demo.accounts a LEFT JOIN demo.orders o ON a.id = o.account_id AND o.occurred_at BETWEEN '2016-08-01' AND '2016-08-31 23:59:59' WHERE o.id is NULL ORDER BY 2
SELECT a.id as customer_id, a.name as customer_name FROM demo.accounts a LEFT JOIN demo.orders o ON a.id = o.account_id AND o.occurred_at BETWEEN '2016-08-01' AND '2016-08-31 23:59:59' WHERE o.id is NULL ORDER BY 2
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-12"> <mode-table id="table_901aee1ba0eb" dataset="dataset" options="table_options"></mode-table> </div> </div> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled