fork download
copy 
  1. SELECT 
  2. CAST ( COUNT ( DISTINCT l.id_user) AS DOUBLE ) / 
  3. CAST ( COUNT ( DISTINCT u.id_user) AS DOUBLE) 
  4. FROM user u 
  5. LEFT OUTER JOIN listings l 
  6. ON u.id_user=l.id_user 
  7. WHERE 
  8. u.city=’paris’ 
  9.  
Compilation error #stdin compilation error #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
compilation info 
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
stdout
copy 
Standard output is empty
https://ideone.com/LELkPJ
language:
Java (HotSpot 12)
created:
6 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!