-
Notifications
You must be signed in to change notification settings - Fork 0
/
load_colleges.sql
13 lines (12 loc) · 1.11 KB
/
load_colleges.sql
1
2
3
4
5
6
7
8
9
10
11
12
insert into college(name, athletic_staff_url, division, state, public, tuition, enrollement,
sat_math_25_pct, sat_math_75_pct, sat_reading_25_pct, sat_reading_75_pct)
values ('Boston College', 'http://www.bceagles.com/school-bio/bc-staff-directory.html', 1, 'MA');
insert into college(name, athletic_staff_url, division, state, public, tuition, enrollement,
sat_math_25_pct, sat_math_75_pct, sat_reading_25_pct, sat_reading_75_pct)
values ('Boston University', 'http://www.goterriers.com/staffdir/bost-staffdir.html', 1, 'MA');
insert into college(name, athletic_staff_url, division, state, public, tuition, enrollement,
sat_math_25_pct, sat_math_75_pct, sat_reading_25_pct, sat_reading_75_pct)
values ('New Hampshire', 'http://www.unhwildcats.com/athleticsDept/directory/index', 1, 'NH');
insert into college(name, athletic_staff_url, division, state, public, tuition, enrollement,
sat_math_25_pct, sat_math_75_pct, sat_reading_25_pct, sat_reading_75_pct)
values ('Providence College', 'http://www.friars.com/staffdir/prov-06-staffdir.html', 1, 'RI');