\begin{sql}
INSERT INTO ORCity \\
SELECT {\blue City\_Type} \\
\> (\>Name, Province, Country, Population,\\
\>\> GeoCoord(Longitude, Latitude)) \\
FROM City \\
WHERE Country = 'D' \\
\>  AND NOT Longitude IS NULL;
\end{sql}