Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

help with SQL statement

May 25, 2003, 3:48 PM
KJones
New User (2 posts)
May 25, 2003, 3:48 PM
Views: 4957
Shortcut
Quote Reply
help with SQL statement
Given the following table, what's the SQL statement to find how many more units a student needs to take in each category?
(SSN is the student's ID #, MIN_UNITS is the minimum units required for the corresponding category.
The table COURSE shows all the courses the student has taken already)

COURSE

SSN COURSE# UNITS COURSE CATEGORY MIN_UNITS
134 11 4 art 30 elective 40
134 15 4 music 34 elective 24
134 25 2 art 55 general 24
134 17 4 art 35 elective 24

Last edited by:

Wil: May 26, 2003, 11:00 AM
Subject Author Views Date
Thread help with SQL statement KJones 4957 May 25, 2003, 3:48 PM
Post Re: [KJones] help with SQL statement 		604 4756 May 26, 2003, 9:38 AM
Post Re: [KJones] help with SQL statement 		brose 4748 May 29, 2003, 8:37 PM