Following query will display one row per vendor who has provided service in city of London and compute sum of the invoice amount of all invoices raised by the vendor

SELECT vendor$\_$id$,$ SUM$($invoice$\_$amount$)$

FROM invoice

WHERE service$\_$city $=$London$$

ORDER BY vendor$\_$id;