SQL CASE Practice Problem 3
February 4, 2014 · Refreshed 2 days ago
Description
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on using CASE, which can be found here:
https://community.modeanalytics.com/sql/tutorial/sql-case/
Collaborators
Tutorial
Run History
SELECT *,
CASE WHEN year IN ('JR', 'SR') THEN player_name ELSE NULL END AS upperclass_player_name
FROM benn.college_football_players
SELECT *,
CASE WHEN year IN ('JR', 'SR') THEN player_name ELSE NULL END AS upperclass_player_name
FROM benn.college_football_players
<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_5c069d766ddd" 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