fmnobar

DROP TABLE IF EXISTS salary;

CREATE TEMPORARY TABLE salary (city VARCHAR(30), average_salary int);

INSERT INTO
	salary
VALUES
	('san_francisco', '54500'),
	('seattle', '54100'),
	('new_york', '34400'),

fmnobar

DROP TABLE IF EXISTS misc_part1;

CREATE TEMPORARY TABLE misc_part1 (
	name VARCHAR(30),
	last_contacted DATE,
	contact_type VARCHAR(30)
);

INSERT INTO
	misc_part1

fmnobar

-- Introduction
 
SELECT column_1, column_2… [Returns entries per specified columns]
SELECT * [Returns all entries]
SELECT DISTINCT column_1, column_2… [Returns unique entries per specified columns]
SELECT DISTINCT * [Returns all unique entries]
 
FROM schema_name.table_name [Specifies table to return entries from]
 
WHERE column_1 = ‘value’ [Specifies condition per column]

fmnobar

fmnobar

fmnobar

fmnobar

Year,City,Sport,Discipline,Athlete,Country,Gender,Event,Medal
1896,Athens,Aquatics,Swimming,"HAJOS, Alfred",HUN,Men,100M Freestyle,Gold
1896,Athens,Aquatics,Swimming,"HERSCHMANN, Otto",AUT,Men,100M Freestyle,Silver
1896,Athens,Aquatics,Swimming,"DRIVAS, Dimitrios",GRE,Men,100M Freestyle For Sailors,Bronze
1896,Athens,Aquatics,Swimming,"MALOKINIS, Ioannis",GRE,Men,100M Freestyle For Sailors,Gold
1896,Athens,Aquatics,Swimming,"CHASAPIS, Spiridon",GRE,Men,100M Freestyle For Sailors,Silver
1896,Athens,Aquatics,Swimming,"CHOROPHAS, Efstathios",GRE,Men,1200M Freestyle,Bronze
1896,Athens,Aquatics,Swimming,"HAJOS, Alfred",HUN,Men,1200M Freestyle,Gold
1896,Athens,Aquatics,Swimming,"ANDREOU, Joannis",GRE,Men,1200M Freestyle,Silver
1896,Athens,Aquatics,Swimming,"CHOROPHAS, Efstathios",GRE,Men,400M Freestyle,Bronze

fmnobar

fmnobar

fmnobar