Recent Activity
Kevin Woo
User for 6 months
Created Content
Recently Created Pages View All
Working with Dates and Times
Data Types for Dates and Times data type description timestamp records date and time times...
Statistical Functions in SQL
Correlation SELECT corr(med_hh_inc, pct_bach_higher) FROM acs_2014_2018_stats; corr --...
Modifying Data + Transactions
Modifying Tables with ALTER TABLE -- add a column ALTER TABLE table_name ADD COLUMN column_name d...
Primary Keys & Foreign Keys
Primary Keys Natural Keys CREATE TABLE natural_key_example ( license_id text CONSTRAINT license...
Basic Math and Stats with SQL
Median with percentile functions CREATE TABLE percentile_test ( numbers integer ); INSER...
Recently Created Chapters View All
Recently Created Books
Kevin Woo has not created any books
Recently Created Shelves
Kevin Woo has not created any shelves