Workspace
Carolyn Boles/

My workspace

0
Beta
Spinner
# Start coding here... 
Unknown integration
DataFrameavailable as
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]');

This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
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);
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
Unknown integration
DataFrameavailable as
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');
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.