fork download 
  1. create table empresas 
  2. (
  3.   id int,
  4.   name varchar(255)
  5. );
  6.  
  7. create table diretores (
  8.   id int,
  9.   name varchar(255),
  10.   empresa int
  11. );
  12.  
  13. insert into empresas (id, name) values (1, "empresa_1");
  14.  
  15. insert into diretores (id, name, empresa) values (1, "diretor_1", 1);
  16. insert into diretores (id, name, empresa) values (2, "diretor_2", 1);
  17.  
  18. select count(*) from diretores where empresa = 1;
Success #stdin #stdout 0s 17192KB
comments (?)
stdin 
Standard input is empty
stdout 
2
https://ideone.com/Q5wNvt
language:
SQLite (sqlite 3.27.2)
created:
7 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!