Rachel Waguespack_DBlabactivity

Rachel Waguespack_DBlabactivity - $22,031 Out-of-State...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Rachel Waguespack February 24, 2011 DB Lab Activity This data set contains various information about the Top 100 Public Colleges in the United States in 2003. We will use this data set to answer the following questions. First, we will add a row with the following information on college #101 in the year 2003. It should contain these facts: In-State Rank 2003 101 In-State Rank 2002 92 Out-of-State Rank 2003 99 School South Harmon College State PA Enrollment 12,234 *SAT/ACT 41 Admission Rate 79% Student/Faculty Ratio 14 4-year Grad. Rate 33%
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6-year Grad. Rate 50% In-State Total Costs $13,460 In-State Costs After Aid $9,412 Total Out-of-State Costs
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $22,031 Out-of-State Costs After Aid $14,778 % Met by Aid 81% Avg. Debt at Grad. $16,119 After adding this data to the database, we need to answer the following questions: 1. Find the schools with an enrollment between 15,000 and 20,000. 2. Find the schools in California with admission rates lower than 30%. 3. Find the schools that have more than 80% Met By Aid and less than $10,000 Avg. Debt at Graduation. 4. Sort the schools by state, and find the state with the most top schools. 5. Find the school with the lowest student/faculty ratio....
View Full Document

This note was uploaded on 04/06/2011 for the course EDC 344 taught by Professor Liu during the Spring '11 term at University of Texas at Austin.

Page1 / 3

Rachel Waguespack_DBlabactivity - $22,031 Out-of-State...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online