sorry to bother you but it's asked to me (my pm)
to create a view from a select like this
SELECT count(id) FROM mytable where field1 IS NOT NULL AND field2 > 1
I put 1 but it can be any other number like 3 ... 1000
All in all it worth create a view for a simple query ?
Thanks in advance.