user: Question: For the prior occupation listed as Assistant Police Commissioner (ret'd) what are the entire list of romanised name. 
Columns: ['Romanised name', 'Chinese name', 'age at appointment', 'Foreign nationality', 'Portfolio attachment', 'Prior occupation', 'Govt salary']
Types: ['text', 'text', 'real', 'text', 'text', 'text', 'text']
Sample row: ['Chan Chi-yuen, Paul', '陳智遠', 28.0, 'N/A', 'Food and Health', 'Research assistant, City University', 'HK$ 134,150']
SQL:

assistant: SELECT "Romanised name" FROM "Table" WHERE "Prior occupation" = 'Assistant Police Commissioner (ret''d)';