Problem with sql sentence

Ye, of course.

I'm making a new chart.
Data are in table but is imposible with options read correct data. Then I have to write sql sentence.

This. sql is running OK in mysql but no in vchart WHY??

SELECT (CASE WHEN p1_ret_realizados < 8 THEN 'Menos de 8 Retos' WHEN p1_ret_realizados >= 8 THEN '8 o más Retos' END) as tipo, count( p1_ret_realizados) as valor FROM hs_historico_datos where co_estadistica=1 and p1_ret_realizados != "" group by tipo order by tipo

VChart change case 1 "<8" for "=8" and delete case ">=9"

I need this sql but i you think that is posible do it using other way tell me. please.

Pardon in sql sentence can not change NOT equal.

Look

SELECT (CASE WHEN p1_ret_realizados < 8 THEN 'Menos de 8 Retos' WHEN p1_ret_realizados >= 8 THEN '8 o más Retos' END) as tipo, count( p1_ret_realizados) as valor FROM hs_historico_datos where co_estadistica=1 and p1_ret_realizados != "" group by tipo order by tipo

The problem is <8 and >= 8

Hi Denise

You have to use not equal option in sql query writing section. I have explained in attach image.

Thanks
Zaheer

Hello I need tell to sql sentence this

where field <> ''

how can i do it??

Thanks