fork download
copy 
  1. SHOW TABLES LIKE 'Railways';
  2.  
  3. -- Query to count the number of trains from each source station
  4. SELECT SourceStation, COUNT(*) AS TrainCount
  5. FROM Railways
  6. GROUP BY SourceStation;
  7. -- your code goes here
Success #stdin #stdout #stderr 0s 5320KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: near "SHOW": syntax error
Error: near line 4: no such table: Railways
https://ideone.com/3WS5qu
language:
SQLite (sqlite 3.27.2)
created:
11 days 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!