<SYSTEM_TASK:>
Solve the following problem using Python, implementing the functions described below, one line at a time
<END_TASK>
<USER_TASK:>
Description:
 def execute_sql(self, query):
 """ Executes a given query string on an open sqlite database. """

        c = self.con.cursor()
        c.execute(query)
        result = c.fetchall()
        return result