EX-01:
Write a T-SQL statement that returns the term, course ID, and the number of times the course was offered in that term. Make sure that the results are sorted by term in ascending order and that each column in the result set has an appropriate column name or alias.
SOLUTION:
EX-02:
Modify the query from EX-01 to only include courses offered in the FA2012 or SP2013 terms and for which there was more than one course offered during the term.
SOLUTION:
EX-03:
Write a T-SQL statement that returns for each member of the faculty: his/her faculty ID, his/her last name, his/her salary, and his/her salary as a percentage of total of all salary values (salary/total salary * 100). Make sure that each column in the result set has an appropriate column name or alias.
SOLUTION:
EX-04:
Write a T-SQL statement that returns for each member of the faculty: his/her faculty ID, his/her last name, his/her salary, his/her department id, the total salary for his/her department, and his/her salary as a percentage of the department's total salary value. Make sure and that each column in the result set has an appropriate column name or alias.
SOLUTION: