Report not found

There was a problem finding this report.
Created in the Mode Community
February 4, 2014 · Refreshed 24 days ago
SQL ORDER BY Practice Problem 4
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

Run History
SELECT * FROM tutorial.billboard_top_100_year_end WHERE year IN (2013, 2003, 1993) --Select the relevant years AND year_rank BETWEEN 10 AND 20 --Limit the rank to 10-20 ORDER BY year, year_rank
SELECT * FROM tutorial.billboard_top_100_year_end WHERE year IN (2013, 2003, 1993) --Select the relevant years AND year_rank BETWEEN 10 AND 20 --Limit the rank to 10-20 ORDER BY year, year_rank
<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_72c054b7fd71" 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. Get help here.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled