new .sql. analysis view updated