Get your own SQL server

SQL Statement:

 
SELECT COUNT(customer_id)
FROM customers
WHERE city = 'London';        

Result:

 count
-------
     6
(1 row)