Skip to content
My workspace
  • AI Chat
  • Code
  • Report
  • # 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.