logo

(solved) SQL Queries Assignment

5 Pages372 Words57 Views
   

Added on  2020-05-11

(solved) SQL Queries Assignment

   Added on 2020-05-11

ShareRelated Documents
Running head: SQL QUERIESSQL QueriesName of the Student:Name of the University:Author Note
(solved) SQL Queries Assignment_1
1SQL QUERIES Answer to question 2.1SELECT academic.deptnum, COUNT(academic.acnum) from academicFULL OUTER JOIN departmentON department.deptnum = academic.deptnumWHERE department.postcode >3000 and department.postcode <3999 and academic.deptnum isNOT NULLGROUP BY academic.deptnumORDER BY COUNT(academic.acnum) DESC;Answer to question 2.4SELECTdepartment.deptnum,department.deptname,department.instname,COUNT(field.fieldnum)FROM departmentFULL OUTER JOIN academicON department.deptnum = academic.deptnumFULL OUTER JOIN interestON academic.acnum = interest.acnumFULL OUTER JOIN fieldON interest.fieldnum = field.fieldnum
(solved) SQL Queries Assignment_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Entity Relationship Modelling Assignment
|17
|2659
|240

Database Concepts: Answers to Questions 1-4
|8
|832
|240

Database Design And Development - Assignment
|9
|884
|27

AAS Database Management Assignment
|9
|625
|122

Database Concepts - Study Material and Solved Assignments
|9
|730
|289

Document on Database SQL
|6
|571
|62