What keyword is missing from the following query in order to ensure that all results, including duplicates, are returned?
The table Office is defined as follows: What would be the order of the rows if the query is rewritten to: SELECT DISTINCT city FROM Office ORDER BY city