SQL RIGHT JOIN Practice Problem
February 6, 2014 · Refreshed 3 days ago
Description
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on using RIGHT JOIN, which can be found here:
https://community.modeanalytics.com/sql/tutorial/sql-right-join/
Collaborators
Tutorial
Run History
SELECT companies.state_code,
COUNT(DISTINCT companies.permalink) AS unique_companies,
COUNT(DISTINCT acquisitions.company_permalink) AS acquired_companies
FROM tutorial.crunchbase_acquisitions acquisitions
RIGHT JOIN tutorial.crunchbase_companies companies
ON companies.permalink = acquisitions.company_permalink
WHERE companies.state_code IS NOT NULL
GROUP BY 1
ORDER BY 3 DESC
SELECT companies.state_code,
COUNT(DISTINCT companies.permalink) AS unique_companies,
COUNT(DISTINCT acquisitions.company_permalink) AS acquired_companies
FROM tutorial.crunchbase_acquisitions acquisitions
RIGHT JOIN tutorial.crunchbase_companies companies
ON companies.permalink = acquisitions.company_permalink
WHERE companies.state_code IS NOT NULL
GROUP BY 1
ORDER BY 3 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_ce32fb22d28b" dataset="dataset" options="table_options"></mode-table>
</div>
</div>
</div>
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