SQL problem

CIS276DB Assignment/Exam Rubric

Assignment: Module 9 Criteria applied to exercise

Student:

1

Criteria Pt Value #1 #2 #3 #4

Correct results from query/executed successfully 4 -6 4 4 4 6

Key words in all capital letters 1 1 1 1 1

Variable Criteria*

Correct number of columns created/returned 3 3 3 3 3 Correct conditional functions & calculations used for

specific view columns 20 20

Correct concatenation used for view column 1 1

Correct table / view joins used 1 - 2 2 1 Correct column qualification(s) used 1 1 1 Correct calculations used for specific view/SELECT

columns 1 - 2 - 7 7 2 1

Correct column aliases used 1 1 1 1 1

Correct CAST/CONVERT function used in query 3 3 Correct subquery used to filter results 2 2

Correct ORDER BY used 1 1

33 16 13 18

Total Points Received for Assignment: 80

Late Submission Point Deduction: 0

Total Points: 80

Notes: Notes (continued):

Exercises

Due Date:

Submitted Date:

Ded Index:

Mesa Community College Spring 2013