Report not found

There was a problem finding this report.
COGS 127 - Search for Commas to Count Items
December 17, 2015 · Refreshed over 3 years ago

Collaborators

Run History
/* What if you want to count how many items they clicked on? What the below does is takes how long the string is (e.g., a,b = 3 characters) and then subtracts how long the string is without commas (ab = 2 characters) -- that means there are 2 items there! This is a quick trick demonstrating the usefulness of basic SQL functions. */ select (length(mealtype)-length(replace(mealtype,',','')))+1 as numSkipped, morningenergy from orionwill.fakedata LIMIT 100
/* What if you want to count how many items they clicked on? What the below does is takes how long the string is (e.g., a,b = 3 characters) and then subtracts how long the string is without commas (ab = 2 characters) -- that means there are 2 items there! This is a quick trick demonstrating the usefulness of basic SQL functions. */ select (length(mealtype)-length(replace(mealtype,',','')))+1 as numSkipped, morningenergy from orionwill.fakedata
<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_75b0f9c3640c" 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.

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