Python for select by attribute then remove from current selection

المشرف العام

Administrator
طاقم الإدارة
I have a table called"July_join". Within this table I have many attributes or columns. I want first to select every thing under "grade" column that has values of 90, then remove from this selection the courses found in "courses" column that are "math", then remove from the resulted selection schools under column "schools" that are "Austin" and "Dallas", then from the resulted selection I want to remove those with only one teacher under "Num_Teachers" were the value is 1. Then the resulted selection I want to export them to a new table. The second new table I want to create is exactly the same as previous, except for the "Num_Teachers" value were I want to remove values that are less than 4.



أكثر...
 
أعلى