I. An overview of SQL:
A) Go to the following site:
http://www.firstsql.com/tutor2.htm
Read about the SELECT statement
B) Go to the following site:
0) Under the Tutorial Section, click on
the link for SELECT.
Work through the problems - be sure to click on the blue links for more infomation
When you are done with this, go to the click on the section SELECT IN SELECT.
Do problems 1a to 1c
1) Under section 2a "More Practice with Select":
Fix the code in sections 1a and 1b.
Do questions 2a - 2c
2) Under Section 3, "Sum and Count"
Do all the questions
3) Under Section 4 "Joins"
Do questions 1a - 1c
Fix the code in question 2a
Do questions 2b and 2c
4) Under "More Join Operations", try to do 1a through 2c and
read the link for
"Get to the point"
REMEMBER THAT THE ANSWERS ARE AVAILABLE, BUT PLEASE TAKE SOME TIME TO
DETERMINE THE ANSWER FOR YOURSELF BEFORE LOOKING AT THE CORRECT CODE