CIS 220, Business Information Systems and Analytics

profileClark1026
DatabaseIIAnswersTemplate.xlsx

Sheet1

Part 1
Question 1: Which industry has the highest average revenue growth?
Answer:
Question 2: Which industry has the highest return on sales?
Answer:
Qustion 3: How many countries had a sum of revenue greater than $100,000 million, i.e. $100 billion?
Answer:
Question 4: How many companies are from Europe?
Answer:
Question 5: Which region has the highest average revenue growth?
Answer:
Part 2
Question 1: How many schools meet the criteria?
Answer:
Question 2: How many states have four or more schools?
Answer:
Qustion 3: What school has the biggest value of Starting Salary minus tuition?
Answer:
Question 4: How many states have at least one month with an average Minimum below zero?
Answer:
Question 5: How many schools have at least 400 applications?
Answer:
Question 6: How many schools are there (with an average GMAT score > 650 and are not ranked in the top 10)?
Answer:
Question 7: How many school have an average January high temperature greater than 60?
Answer: