fork download
copy 
  1. -- Check if the Railways table exists (for SQLite)
  2. SELECT name FROM sqlite_master WHERE type='table' AND name='Railways';
  3.  
  4. -- Query to count the number of trains from each source station
  5. SELECT SourceStation, COUNT(*) AS TrainCount
  6. FROM Railways
  7. GROUP BY SourceStation;
  8. -- 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 5: no such table: Railways
https://ideone.com/2DAZGL
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!