Armazene seus dados

Aplicando SQL a Problemas do Mundo Real

Dmitriy (Dima) Gorenshteyn

Lead Data Scientist, Memorial Sloan Kettering Cancer Center

Três formas de armazenar seus dados

Colunas na tabela address

1) Criar uma nova tabela

CREATE TABLE zip_distance (
    postal_code INT,
    distance FLOAT
);

2) Inserir dados na tabela

INSERT INTO zip_distance (postal_code, distance)
VALUES
(53182, 3.4),                
(15540, 10.2),                
(67912, 1.9);


SELECT film_id, title
FROM film
WHERE rating = 'G';

CREATE TABLE family_films AS
SELECT film_id, title
FROM film
WHERE rating = 'G';

CREATE VIEW family_films AS
SELECT film_id, title
FROM film
WHERE rating = 'G';

Aplicando SQL a Problemas do Mundo Real