Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
teste
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
drop table if exists cli, viag, pass; create table cli (id int, nome varchar(20)); create table viag (id int, titulo varchar(40)); create table pass (id int, id_cliente int, id_viagem int); insert into cli(id, nome) values (1, 'bruno'), (2, 'tamires'), (3, 'christen wiggins'), (4, 'justine howard'), (5, 'anika hammond'), (6, 'alea vang'), (7, 'fredericka jensen'), (8, 'alexa duncan'), (9, 'lynn mclean'), (10, 'allegra cantrell'); insert into viag (id, titulo) values (1, 'gramado'), (2, 'gramado - mundo magico'), (3, 'beto carrero'), (4, 'caminhos rurais'); insert into pass (id, id_cliente, id_viagem) values (1, 1, 1), (2, 2, 1), (3, 3, 1), (4, 4, 1), (5, 5, 1), (6, 6, 2), (7, 7, 2), (8, 8, 2), (9, 9, 2), (10, 10, 2), (11, 1, 3), (12, 2, 3), (13, 3, 3), (14, 1, 4), (15, 2, 4), (16, 3, 4), (17, 8, 4), (18, 9, 4), (19, 10, 4); SELECT p.id, c.nome, v.titulo, (select count(*) from pass p2 where p2.id_viagem = p.id_viagem) as total FROM pass AS p LEFT JOIN cli AS c ON c.id = p.id_cliente LEFT JOIN viag AS v ON v.id = p.id_viagem
absolute service time: 0,39 sec
edit mode
|
history
id
nome
titulo
total
1
1
bruno
gramado
5
2
2
tamires
gramado
5
3
3
christen wiggins
gramado
5
4
4
justine howard
gramado
5
5
5
anika hammond
gramado
5
6
6
alea vang
gramado - mundo magico
5
7
7
fredericka jensen
gramado - mundo magico
5
8
8
alexa duncan
gramado - mundo magico
5
9
9
lynn mclean
gramado - mundo magico
5
10
10
allegra cantrell
gramado - mundo magico
5
11
11
bruno
beto carrero
3
12
12
tamires
beto carrero
3
13
13
christen wiggins
beto carrero
3
14
14
bruno
caminhos rurais
6
15
15
tamires
caminhos rurais
6
16
16
christen wiggins
caminhos rurais
6
17
17
alexa duncan
caminhos rurais
6
18
18
lynn mclean
caminhos rurais
6
19
19
allegra cantrell
caminhos rurais
6