correct misspelling of measurements and deployments tables and use ; not : to terminate sql statements