fork download
copy 
  1. SELECT
  2.   DATE(s.transaction_date) as day,
  3.   d.name as department,
  4.   COUNT(s.id) as sale_count
  5.   FROM sale s
  6.     JOIN department d on d.id = s.department_id
  7.   group by d.name, s.transaction_date
Success #stdin #stdout #stderr 0s 17192KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: no such table: sale
https://ideone.com/RT3vJW
language:
SQLite (sqlite 3.27.2)
created:
8 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!