create view to query all