This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Spring 2010: ISAM 5331 / ACCT 5333 Copyright © 2010 Richard Meyer. All rights reserved. This material may not be reproduced, displayed, modified or distributed without the express prior written permissions of the copyright holder. Homework Assignment 07 For the following questions please provide the answers using the Courier New font in Microsoft Word, or optionally in a plain text (TXT) file. Please refer to Homework 3 for re-installing the STU database and spooling output. Remember to include your Full Name, Class Number, and Date at the top of the file. You must submit this homework assignment though WebCT to the Instructor and the Teaching Assistant. If you wish to receive a printed copy of your evaluation, please request so at the top of your submission. Provide the Oracle SQL Statements , and a copy of the output , that provide the best solution to the following: 1. Using sub-queries and outer-joins: a. select the last and first name of students, and their grades b. Where students have a matching test 1 or have a matching test 2 score. c. Use single row functions to default any null grades to 0 d. Hints: i. Use two IN subqueries or use an EXISTS subquery ii. Make sure you do not match against the same student in the subquery...
View Full Document
- Spring '10
- Networking, Homework help service, single row functions, Richard Meyer, null grades