Chapter 15
Review
“But there are advantages to being elected President. The day after I was elected, I had my high school grades classified Top Secret. “
Table of Contents Chapter 15 – Review
Testing Your Knowledge
SELECT everything (all columns) from the Student_Table.
Testing Your Knowledge
Now you should SELECT the Student_ID, Last_Name, First_Name, and Class_Code from the Student_Table.
Testing Your Knowledge
Now you should SELECT the Student_ID, Last_Name, First_Name, and Class_Code from the Student_Table. Order By Class_Code.
Testing Your Knowledge
Now you should SELECT the Student_ID, Last_Name, First_Name, and Class_Code from the Student_Table. Only show the rows that have the Class_Code FR, JR, SR. Order By Class_Code.
Testing Your Knowledge
Now you should SELECT the Student_ID, Last_Name, First_Name, and Class_Code from the Student_Table. Only show the rows that have the Class_Code FR, JR, SR and if the First_Name ends in an ‘y’. Order By Class_Code.
Testing Your Knowledge
Now you should SELECT the Student_ID, Last_Name, First_Name, and Class_Code from the Student_Table. Only show the rows that have the Class_Code FR, JR, SR and if the First_Name ends in an ‘y’ AND if their Last_Name ends in ‘y’. Order By Class_Code.
Testing Your Knowledge
Select Student_ID, Last_Name, First_Name, Class_Code
From Student_Table
Where Class_Code In ('FR','JR', 'SR')
And First_Name LIKE '%y'
And Trim(Last_Name) LIKE '%y'
Order By Class_Code
This should be your final answer set. The query under it should be approximately what you wrote to attain such an answer set. How'd you do?