SQL OR Practice Problem 1
February 3, 2014 · Refreshed 2 days ago
Description
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on using the OR operator, which can be found here:
https://community.modeanalytics.com/sql/tutorial/sql-or-operator/
Collaborators
Tutorial
Run History
SELECT *
FROM tutorial.billboard_top_100_year_end
WHERE year_rank <= 10
AND ("group" ILIKE '%katy perry%' OR "group" ILIKE '%bon jovi%')
SELECT *
FROM tutorial.billboard_top_100_year_end
WHERE year_rank <= 10
AND ("group" ILIKE '%katy perry%' OR "group" ILIKE '%bon jovi%')
<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_dc347994b983" 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