There is a more recent run of this report. Click here to view it.

Report not found

There was a problem finding this report.
SQL Joins Using WHERE or ON Practice Problem 2
February 7, 2014 · Refreshed 43 minutes ago
Description
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on filtering joins with WHERE or ON, which can be found here: https://community.modeanalytics.com/sql/tutorial/sql-joins-where-vs-on/

Collaborators

Run History
SELECT CASE WHEN investments.investor_name IS NULL THEN 'No Investors' ELSE investments.investor_name END AS investor, COUNT(DISTINCT companies.permalink) AS companies_invested_in FROM tutorial.crunchbase_companies companies LEFT JOIN tutorial.crunchbase_investments investments ON companies.permalink = investments.company_permalink GROUP BY 1 ORDER BY 2 DESC
SELECT CASE WHEN investments.investor_name IS NULL THEN 'No Investors' ELSE investments.investor_name END AS investor, COUNT(DISTINCT companies.permalink) AS companies_invested_in FROM tutorial.crunchbase_companies companies LEFT JOIN tutorial.crunchbase_investments investments ON companies.permalink = investments.company_permalink GROUP BY 1 ORDER BY 2 DESC
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-table id="table_b39c11e39bc8" 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