sqlzoo NSS Tutorial

最新推荐文章于 2024-07-19 07:01:13 发布

ゞ泥想干哈

最新推荐文章于 2024-07-19 07:01:13 发布

阅读量83

点赞数 1

文章标签：数据库 sql

本文链接：https://blog.csdn.net/qq_51491409/article/details/140405297

版权

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

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

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

SELECT subject,sum(response)
  FROM nss
 WHERE question='Q22'
   AND (subject='(8) Computer Science' or subject='(H) Creative Arts and Design')
group by subject

SELECT subject,sum(A_STRONGLY_AGREE/100*response)
  FROM nss
 WHERE question='Q22'
   AND (subject='(8) Computer Science' or subject='(H) Creative Arts and Design' )
group by subject

SELECT subject,round(100*sum(A_STRONGLY_AGREE*response/100)/sum(response),0)
  FROM nss
 WHERE question='Q22'
   AND (subject='(8) Computer Science' or subject='(H) Creative Arts and Design')
group by subject

SELECT institution,round(100*sum(score/100*response)/sum(response),0)
  FROM nss
 WHERE question='Q22'
   AND (institution LIKE '%Manchester%')
group by institution
ORDER BY institution

SELECT institution,sum(sample),(select sample from nss x where question='Q01' AND subject='(8) Computer Science'and x.institution=y.institution)
  FROM nss y
 WHERE question='Q01'
   AND (institution like '%Manchester%') 
group by institution