8+ Numeric Examples

Lesson

1) SELECT A_STRONGLY_AGREE
  FROM nss
 WHERE question='Q01'
   AND institution='Edinburgh Napier University'
   AND subject='(8) Computer Science';

2) SELECT institution, subject
  FROM nss
 WHERE question='Q15'
   AND score >= 100;

3) SELECT institution,score
  FROM nss
 WHERE question='Q15'
   AND score < 50
   AND subject='(8) Computer Science';

4) SELECT subject, SUM(response)
  FROM nss
 WHERE question='Q22'
   AND (subject='(8) Computer Science' OR subject='(H) Creative Arts and Design')
GROUP BY subject;

5) SELECT subject, SUM(response * A_STRONGLY_AGREE / 100)
  FROM nss
 WHERE question='Q22'
   AND (subject='(8) Computer Science' OR subject='(H) Creative Arts and Design')
GROUP BY subject;

6) SELECT subject, 
ROUND(SUM(response * A_STRONGLY_AGREE / 100) / SUM(response) * 100, 0)
  FROM nss
 WHERE question='Q22'
   AND (subject='(8) Computer Science' OR subject='(H) Creative Arts and Design')
GROUP BY subject;

7) SELECT institution, ROUND(SUM(score *  response) / SUM(response), 0)
  FROM nss
 WHERE question='Q22'
   AND (institution LIKE '%Manchester%')
GROUP BY institution
ORDER BY institution;

8) SELECT institution, SUM(sample), (SELECT sample FROM nss y
									 WHERE subject='(8) Computer Science'
									 	AND x.institution = y.institution
									 	AND question='Q01') AS comp
   FROM nss x
   WHERE question='Q01'
   		AND (institution LIKE '%Manchester%')
   GROUP BY institution;