added api test sql