sql statement for views / testing