SELECT
CAST ( COUNT ( DISTINCT l.id_user) AS DOUBLE ) /
CAST ( COUNT ( DISTINCT u.id_user) AS DOUBLE)
FROM user u
LEFT OUTER JOIN listings l
ON u.id_user=l.id_user
WHERE
u.city=’paris’
U0VMRUNUIApDQVNUICggQ09VTlQgKCBESVNUSU5DVCBsLmlkX3VzZXIpIEFTIERPVUJMRSApIC8gCkNBU1QgKCBDT1VOVCAoIERJU1RJTkNUIHUuaWRfdXNlcikgQVMgRE9VQkxFKSAKRlJPTSB1c2VyIHUgCkxFRlQgT1VURVIgSk9JTiBsaXN0aW5ncyBsIApPTiB1LmlkX3VzZXI9bC5pZF91c2VyIApXSEVSRSAKdS5jaXR5PeKAmXBhcmlz4oCZIAo=
Main.java:1: error: class, interface, or enum expected
SELECT
^
Main.java:8: error: illegal character: '\u2019'
u.city=?paris?
^
Main.java:8: error: illegal character: '\u2019'
u.city=?paris?
^
3 errors