SQL Syntax

Homework 

Musings
on VB

Office Hours 

Contact Me 

Programming Rules 

Final Grades

send me
an e-mail

• Final grades are posted.

• Homework comments will soon be emailed.

• There is a small type on homework 7. The correct SQL statement to retireve everyone in alphabetical order should be

  SELECT MASTER.PLAYERID, NAMEFIRST AS FIRSTNAME, 
      NAMELAST AS LASTNAME, 
      NAMELAST+IIF(LEN(NAMEFIRST)>0,', '+NAMEFIRST,'') AS FULLNAME, 
      SUM(AB) AS ATBATS, SUM(H) AS HITS,
      IIF(SUM(AB)>0,INT(1000*SUM(H)/SUM(AB)+0.5),-1) AS BATAVG,
      IIF(SUM(AB)>0,INT(1000*(SUM(H)+SUM([2B])+2*
      SUM([3B])+3*SUM(HR))
      /SUM(AB)+0.5),-1) AS SLUGPCTG, MAX(YEARID) AS LASTSEASON,
      MIN(YEARID) AS FIRSTSEASON, SUM([2B]) AS DOUBLES, 
      SUM([3B]) AS TRIPLES, SUM(HR) AS HOMERUNS, SUM(BB) AS WALKS, 
      SUM(SO) AS STRIKEOUTS, SUM(SB) AS STEALS, BIRTHDAY,
      BIRTHMONTH, BIRTHYEAR, BIRTHCOUNTRY, BATS, THROWS, WEIGHT, HEIGHT, 
      SUM(RBI) AS RBIS, SUM(R) AS RUNS, SUM(SF) AS SACFLIES, 
      SUM(HBP) AS HITBYPITCH
  
  FROM MASTER, BATTING
  
  WHERE MASTER.PLAYERID = BATTING.PLAYERID
  
  GROUP BY MASTER.PLAYERID, NAMEFIRST, 
      NAMELAST, BIRTHDAY,
      BIRTHMONTH, BIRTHYEAR, BIRTHCOUNTRY, BATS, THROWS, WEIGHT, HEIGHT
  
  HAVING SUM(AB) >= 0
  
  ORDER BY NAMELAST+IIF(LEN(NAMEFIRST)>0,', '+NAMEFIRST,'') 
  

  In calculating the slugging percentage, I inadvertently left off the "R" of the homerun term in formula. You can tell whether you have it by looking at Hank Aaron's stats. His career slugging percentage should be 555 not the value in excess of 1200 you get from the formula I first had.

• Grades for homework 4 are posted and comments have been sent.

  If you do not see a grade for yourself, it is because you did not send anything to mis34032@yahoo.com.

• Homework 6 is posted.

• Homework 5 is posted.

• Homework 4 is posted.

• Grades and comments for homework 2 have been posted.

• If you wish to try homework 2 a second time (or a first time if you never turned it in) to improve your grade, please feel free to do so. You need to submit it to MIS34032@yahoo.com, as a zip file, by midnight Wednesday February 28, 2007. Please clearly word the subject of your email so I know it is a resubmission of homework 2. I will grade whatever you submit by that time. Only the better of your two grades on homework 2 will be counted.

• Office hours for Spring, 2007 have been changed. They are now Tuesday and Thursday from 2:00 p.m. to 3:30 p.m. and Wednesday from 2:00 p.m. to 4:00 p.m.

• J.M. Smuckers just notified us of several internships it will be offering this summer. If you check the Internship Page they should soon be posted there.

• Homework 3 is posted.

• Class is cancelled the evening of February 8, 2007 so you will have the time to attend the event below.

  If you have not already, you'll be receiving an email from Greg Mulhollen at GMulhollen@OneStopShipping.Com inviting you to a dinner on February 8, 2007 at the Pufferbelly restaurant in Kent. The purpose is to get your feelings regarding the CIS major. What is done well/poorly. What is not being done that should be. etc. In exchange for your feedback, which will be reflected in our curricular revisions, the meal is on Greg. If you can, please let him know you'll attend.

  Neither I nor anyone else teaching major courses will be at the meeting. So, please feel free to give your opinions to Greg knowing they will be anonymously reported to us.

• Grades for homework 1 are posted. You should receive an email shortly with your grade ID.

• Homeworks 1 and 2 are posted.

• This page will be used to post announcements relevant to this class. For example, when a homework is posted to the web or graded, this will be noted here. Check it frequently.

• To use the grade page, you need to know your course ID. It will be sent to you via email when you complete homework 1.