added queries and views to demonstrate queries results