Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Caronas
CREATE TABLE MOTORISTAS( id CHAR(8) NOT NULL, nome VARCHAR(60) NOT NULL, num_registro CHAR(12) NOT NULL, med_aval FLOAT NOT NULL, PRIMARY KEY(id)); CREATE TABLE PASSAGEIROS( id CHAR(8) NOT NULL, nome VARCHAR(60) NOT NULL, PRIMARY KEY(id)); CREATE TABLE VIAGENS( motorista_id CHAR(8) NOT NULL, passageiro_id CHAR(8) NOT NULL, data_inicio TIMESTAMP NOT NULL, km_rodados INT, FOREIGN KEY (motorista_id) REFERENCES MOTORISTAS, FOREIGN KEY (passageiro_id) REFERENCES PASSAGEIROS);
run
|
edit
|
history
|
help
0
SALESPEOPLE
robot-grading
PIVOT AND UNPIVOT USING XML PARSING
TUAN 8_BTTL
Sample
String agg
Generate xml
Preppin Data Challenge - Week 7
Program 3 Lab Assignment
Demo