Table: pdps_chapters
Columns: greek_designation
collegiate_institution
charter_date
status
city
u_s_state_district

Question: What California city has an active status and a greek designation of established colony?
SQL: SELECT "city" FROM pdps_chapters WHERE "status" = 'active' AND "u_s_state_district" = 'california' AND "greek_designation" = 'established colony'

Question: What's the greek designation of the new york chapter with a charter date of april 23, 2005?
SQL: SELECT "greek_designation" FROM pdps_chapters WHERE "u_s_state_district" = 'new york' AND "charter_date" = 'april 23, 2005'

Question: What collegiate institution has an active status and a charter date of march 30, 2002?
SQL: SELECT "collegiate_institution" FROM pdps_chapters WHERE "status" = 'active' AND "charter_date" = 'march 30, 2002'

Question: What's the greek designation of the city riverside?
SQL: SELECT "greek_designation" FROM pdps_chapters WHERE "city" = 'riverside'

Question: What city has a charter date of november 24, 1999?
SQL: SELECT "city" FROM pdps_chapters WHERE "charter_date" = 'november 24, 1999'

Question: What state or district has a charter date of april 17, 2011?
SQL: SELECT "u_s_state_district" FROM pdps_chapters WHERE "charter_date" = 'april 17, 2011'