Column does not exist

Dremio University
1

with base as (
select
count(distinct image_id) as images,
count(distinct track_id) as tracks,
count(unique_id) as boxes,
trafficSignClass
from athena.laendle_boxes_v1
group by trafficSignClass
),
base_1 as (
select
trafficSignClass as ts_class,
1.0boxes/images as AVG_BOX_PER_IMG,
1.0boxes/tracks as AVG_BOX_PER_TRACK,
1.0*images/tracks as AVG_IMG_PER_TRACK,
images,
boxes,
tracks
from base
)
select * from base_1 where ts_class = “NOSTOP”

This gives an error: Column ‘NOSTOP’ not found in any table

2

@sudarshan Welcome to the Dremio community,

Since ‘NOSTOP’ is a literal, it has to be wrapped around single quotes (’), if we wrap it around double quotes ("), then it refers to a column name in one one of the datasets used in the SQL