Module: HW $-$ Basic Select Univ. Mode: Tutor Mode Query: G $(0011$ attempts$/$e

Return to Module Page

Query $($G$)$

Enter SQL:

Write a query to calculate the total credit hours taught in

SELECT $*$

Fall $2002($i$.$e$.,$ number of students enrolled in each class

FROM courses

in Fall $2002$ times the number of credit hours for the class$).$ Assume that each course is $3$ credits. The header for the total credit hours should be named HOURS.

$\backslash$table$[[$COURSENUMM$,$NAME,CREDITS$],[$ACTG $311,$Cost Accounting,$4],[$ACTG $313,$Intermediate Accounting I,$3],[$ACTG $314,$Intermediate Accounting II$,3],[$ACTG $316,$Accounting Information Systems,$3],[$MGNT $321,$Principles of Management,$3],[$MGNT $322,$Organizational Behavior,$3]]$