Skip to content
# Start coding here... 
Spinner
DataFrameas
Contact
variable


INSERT INTO Contact(cellphone, homephone, email) VALUES
    (5121325343, 5125234234, '[email protected]'),
    (5129739834, 5129847873, '[email protected]'),
    (6453898502, 6459872345, '[email protected]'),
    (8763238756, 8763736548, '[email protected]'),
    (8880345966, 8888567987, '[email protected]'),
    (3322827765, 3328760098, '[email protected]');

Spinner
DataFrameas
df1
variable
CREATE TABLE Address(
    id int,
    address1 VARCHAR,
    address2 VARCHAR,
    city CHAR,
    state CHAR,
    zip int);

INSERT INTO Address(address1, address2, city, state, zip) VALUES
    ('1211 Sudan St', 'n/a', 'Mobile', 'AL', 36609),
    ('4800 Barkshire Dr', 'n/a', 'Pace', 'FL', 32571),
    ('12 Nutmeg Ct', 'n/a', 'Culver City', 'CA', 90211),
    ('2142 Elmwood Pl', 'n/a', 'Johnson City', 'TN', 37112),
    ('777 Heavenly Ln', 'Box 13', 'Pike City', 'MN', 50877);
Spinner
DataFrameas
df2
variable
-- Database Tables is empty. No need to drop tables; 
CREATE TABLE Employee( 
    id int, 
    fname char, 
    lname char, 
    age int, 
    hiredate date); 
INSERT INTO Employee (fname, lname, age, hiredate) VALUES 
    ('Alan','Palmer', 32, '2019-12-15'),
    ('Susan', 'Shepard', 28, '2015-07-21'),
    ('Justin', 'Ward', 43, '2017-08-24'),
    ('Alan', 'Smith', 30, '2017-06-22'),
    ('James', 'Betternot', 26, '2017-06-22'),
    ('Ralph', 'White', 44, '2017-06-23'),
    ('Leonard', 'Nimoy', 72, '2007-12-14'),
    ('Janice', 'Rand', 61, '2016-07-06'),
    ('Harry', 'Mudd', 65, '2020-07-06'),
    ('Hikaru', 'Sulu', 58, '2015-03-21'),
    ('James', 'Kirk', 59, '2014-01-02'),
    ('Leonard', 'McCoy', 65, '2015-08-21'),
    ('Pavel', 'Chekov', 44, '2014-10-15'),
    ('Christopher', 'Pike', 32, '2014-11-24'),
    ('Darth', 'Vader', 124, '2015-03-22'),
    ('Boba', 'Fett', 49, '2015-03-22'),
    ('Luke', 'Skywalker', 66, '2019-11-11'),
    ('Han', 'Solo', 73, '2012-02-03'),
    ('Kylo', 'Ren', 34, '2020-06-14'),
    ('Galen', 'Erso', 55, '2020-06-14');