SQL Comparison Operators Practice Problem 5
February 4, 2014 · Refreshed 7 days ago
Description
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on using comparison operators, which can be found here:
https://community.modeanalytics.com/sql/tutorial/sql-operators/
Collaborators
Tutorial
Run History
SELECT year,
month,
west,
south,
midwest,
northeast,
west + south + midwest +northeast AS usa_total
FROM tutorial.us_housing_units
SELECT year,
month,
west,
south,
midwest,
northeast,
west + south + midwest +northeast AS usa_total
FROM tutorial.us_housing_units
<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_9515ce83061f" 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