adding semicolon and some convenience sql