Difference between revisions of "NSS Tutorial"
From SQLZOO
(→Check out one row) |
|||
| Line 20: | Line 20: | ||
<source lang='sql' class='ans'> | <source lang='sql' class='ans'> | ||
| − | SELECT | + | SELECT A_STRONGLY_AGREE |
FROM nss | FROM nss | ||
WHERE question='Q01' | WHERE question='Q01' | ||
Revision as of 23:40, 9 December 2012
National Student Survey 2012
The National Student Survey http://www.thestudentsurvey.com/ is presented to thousands of graduating students in UK Higher Education. The survey asks 22 questions, students can respond with STRONGLY DISAGREE, DISAGREE, NEUTRAL, AGREE or STRONGLY AGREE.
The table nss has one row per institution, subject and question.
Check out one row
The example shows the number who responded for:
- question 1
- at 'Edinburgh Napier University'
- studying '(8) Computer Science'
Show the the percentage who STRONGLY AGREE
SELECT respond FROM nss WHERE question='Q01' AND institution='Edinburgh Napier University' AND subject='(8) Computer Science'
SELECT A_STRONGLY_AGREE FROM nss WHERE question='Q01' AND institution='Edinburgh Napier University' AND subject='(8) Computer Science'