Skip to content

Instantly share code, notes, and snippets.

View gsisko's full-sized avatar

Gabriel Isko gsisko

  • Tempe, AZ
View GitHub Profile
@gsisko
gsisko / queries.sql
Last active January 27, 2021 06:21
SQL Queries for ADP interview questions
#Show Mariopa County Database
SELECT * FROM maricopa;
#Show Pima County Database
SELECT * FROM pima;
#Combine Maricopa and Pima databases
SELECT maricopa_id AS cumulative_id, party, age, gender FROM maricopa
UNION
SELECT pima_id as cumulative_id, party, age, gender FROM pima;
@gsisko
gsisko / example.sql
Last active January 27, 2021 06:21
SQL Schema for ADP interview questions
CREATE TABLE STATE(
state_id INT NOT NULL,
party VARCHAR(30) NOT NULL,
age INT NOT NULL,
gender VARCHAR(15) NOT NULL,
PRIMARY KEY(state_id));
INSERT INTO STATE(state_id, PARTY, AGE, GENDER)
VALUES (123, 'D', 20, 'F');
INSERT INTO STATE(state_id, PARTY, AGE, GENDER)
from selenium import webdriver
from webdriver_manager.chrome import ChromeDriverManager
driver = webdriver.Chrome(ChromeDriverManager().install())
url = 'https://www.carvana.com/cars'
driver.get(url)
_html = driver.page_source
@gsisko
gsisko / untitled1.ipynb
Created January 29, 2019 02:02
CarData_Analysis.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.