Kusto: Copy rows from one table and Append to the other within the same cluster

Question

In Kusto, is there any way to copy rows from one table and append to the other within the same cluster?

For example, I want to only copy the rows with student data with gender of female to the other table.

Student
| where gender has 'female'

Answer 1

.set-or-append OtherTable <| Student | where gender has 'female'