SQL ORDER BY Practice Problem 3
February 3, 2014 · Refreshed 10 days ago
Description
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on using ORDER BY to sort data, which can be found here:
https://community.modeanalytics.com/sql/tutorial/sql-order-by/
Collaborators
Tutorial
Run History
SELECT *
FROM tutorial.billboard_top_100_year_end
WHERE "group" ILIKE '%t-pain%'
ORDER BY year_rank DESC
SELECT *
FROM tutorial.billboard_top_100_year_end
WHERE "group" ILIKE '%t-pain%'
ORDER BY year_rank 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_cfe0144aca9d" 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