Q1) in the sql code below find and correct all the errors.Write down the errors and how you solved them and complete the following task:

-Display the distinct values of staff names from the Sale table.

-In the Academic table, group by deptnum then display the count of their occurrence.

-Display all values in the Academic table where the department number = 100

-Display all values in the Department table where the department name has the word computer in it.

Note: You are not allowed to change, add or remove columns/attributes

the code:

create table DEPARTMENT ( DEPTNUM integer not null, DESCRIP char(10), INSTNAME char(80), DEPTNAME char(80), STATE char(4), POSTCODE integer, primary key (DEPTNUM) );

create table ACADEMIC ( ACNUM integer not null, DEPTNUM char(1) not null, FAMNAME char(20), GIVENAME char(20), INITIALS char(10), TITLE char(10), primary key (ACNUM), foreign key (DEPTNUM) references DEPARTMENT(DEPTNUM) );

create table PAPER ( PANUM integer not null, TITLE int, primary key (PANUM) );

create table AUTHOR ( PANUM enum(1) not null, ACNUM enum(1) not null, foreign key (PANUM) references PAPER(PANUM), foreign key (ACNUM) references ACADEMIC(ACNUM) );

create table FIELD ( FIELDNUM integer not null, ID char(10) not null, TITLE char(80), primary key (FIELDNUM) );

create table INTEREST ( FIELDNUM integer not null, ACNUM integer not null, DESCRIP char(80), foreign key (FIELDNUM) references FIELD(FIELDNUM), foreign key (ACNUM) references ACADEMIC(ACNUM) );

insert into DEPARTMENT values (100, 'GU CIT', 'Griffith University', 'School of Computing and Information Technology', 'Qld', 4111); insert into DEPARTMENT values (101, 'JCU CS', 'James Cook University of North Queensland', 'Computer Science', 'Qld', 4811); insert into DEPARTMENT values (102, 'LTU CSCE', 'La Trobe University', 'Computer Science and Computer Engineering', 'VIC', 3083); insert into DEPARTMENT values (103, 'MQU MPCE', 'Macquarie University', 'Computing', 'NSW', 2109); insert into DEPARTMENT values (104, 'MQU RCASE', 'Macquarie University', 'JRCASE', 'NSW', 2109); insert into DEPARTMENT values (105, 'MNU CS', 'Monash University (Clayton)', 'Computer Science', 'VIC', 3168); insert into DEPARTMENT values (106, 'MRU CS', 'Murdoch University', 'Computer Science', 'WA', 6150); insert into DEPARTMENT values (107, 'NUS ISCS', 'National University of Singapore', 'Information Systems and Computer Science', '', 0); insert into DEPARTMENT values (108, 'QUT CS', 'Queensland University of Technology', 'Computing Science', 'QLD', 4000); insert into DEPARTMENT values (109, 'SUT IT', 'Swinburne University of Technology', 'School of Information Technology', 'VIC', 3122); insert into DEPARTMENT values (110, 'ANU CSL', 'Australian National University', 'Computer Science Laboratory', 'ACT', 0200); insert into DEPARTMENT values (111, 'ADFA CS', 'University College - ADFA - UNSW', 'Computer Science', 'ACT', 2600); insert into DEPARTMENT values (112, 'UA CS', 'University of Adelaide', 'Computer Science', 'SA', 5005); insert into DEPARTMENT values (113, 'UC ISE', 'University of Canberra', 'Information Sciences and Engineering', 'ACT', 2616); insert into DEPARTMENT values (114, 'UNE MSCS', 'University of New England', 'Mathematics - Statistics and Computing Science', 'NSW', 2351); insert into DEPARTMENT values (115, 'UNC CS', 'University of Newcastle', 'Computer Science', 'NSW', 2308); insert into DEPARTMENT values (116, 'UQ IT', 'University of Queensland', 'School of Information Technology', 'Qld', 4072); insert into DEPARTMENT values (118, 'FU CS', 'Flinders University', 'Department of Computer Science', 'SA', 5001);

insert into PAPER values (0001, 'Performance of synchronized iterative processes in multiprocessor systems'); insert into PAPER values (0002, 'On the combined problem of compaction and sorting'); insert into PAPER values (0003, 'The interpretation of meta grammars describing syntax-directed interpreters'); insert into PAPER values (0004, 'A specification method for specifying data and procedural abstractions'); insert into PAPER values (0005, 'Specification and verification of communication protocols'); insert into PAPER values (0006, 'Program specification applied to a text formatter'); insert into PAPER values (0007, 'Specification of forms processing and business procedures'); insert into PAPER values (0008, 'On horizontally microprogrammed microarchitecture description techniques'); insert into PAPER values (0009, 'Display condensation of program text'); insert into PAPER values (0010, 'On a class of linear maps for data compression'); insert into PAPER values (0011, 'Implementation of the database machine DIRECT'); insert into PAPER values (0012, 'View modeling and integration using the functional data model'); insert into PAPER values (0013, 'Protocols for deadlock detection in distributed database systems'); insert into PAPER values (0014, 'A family of locking protocols'); insert into PAPER values (0015, 'The logical access path schema of a database'); insert into PAPER values (0016, 'Auditing and inference control in statistical databases'); insert into PAPER values (0017, 'A mechanism for database protection in cellular logic devices'); insert into PAPER values (0018, 'Unidirectional transport of rights and take-grant control'); insert into PAPER values (0019, 'Databases and units of measure');

insert into AUTHOR values (0001, 100); insert into AUTHOR values (0001, 101); insert into AUTHOR values (0002, 102); insert into AUTHOR values (0003, 103); insert into AUTHOR values (0003, 104); insert into AUTHOR values (0004, 105); insert into AUTHOR values (0005, 106); insert into AUTHOR values (0005, 107); insert into AUTHOR values (0005, 108); insert into AUTHOR values (0005, 109); insert into AUTHOR values (0005, 111); insert into AUTHOR values (0006, 113); insert into AUTHOR values (0007, 114);

nsert into FIELD values (292, 'B.', 'Hardware'); insert into FIELD values (293, 'B.0', 'General'); insert into FIELD values (294, 'B.1', 'Control Structures and Microprogramming'); insert into FIELD values (295, 'B.1.3', 'Control Structure Reliability - Testing and Fault-Tolerance'); insert into FIELD values (296, 'B.1.5', 'Microcode Applications'); insert into FIELD values (297, 'B.2', 'Arithmetic and Logic Structures'); insert into FIELD values (298, 'B.2.4', 'Miscellaneous'); insert into FIELD values (299, 'B.3', 'Memory Structures'); insert into FIELD values (300, 'B.3.2', 'Design Styles'); insert into FIELD values (301, 'B.3.3', 'Performance Analysis and Design Aids'); insert into FIELD values (302, 'B.4.2', 'Input/output Devices'); insert into FIELD values (303, 'B.4.3', 'Interconnections (subsystems)'); insert into FIELD values (304, 'B.4.5', 'Reliability - Testing and Fault-Tolerance'); insert into FIELD values (305, 'B.5', 'Register Transfer Level Implementation'); insert into FIELD values (306, 'B.6', 'Logic Design'); insert into FIELD values (307, 'B.7', 'Integrated Circuits'); insert into FIELD values (308, 'C.', 'Computer Systems Organization'); insert into FIELD values (309, 'C.1', 'Processor Architectures'); insert into FIELD values (310, 'C.1.1', 'Single Data Stream Architectures'); insert into FIELD values (311, 'C.1.2', 'Multiple Data Stream Architectures'); insert into FIELD values (312, 'C.1.3', 'Other Architecture Styles'); insert into FIELD values (313, 'C.2', 'Computer Communication Networks');

insert into INTEREST values (292, 100, 'Multiprocessor and Special purpose computer design'); insert into INTEREST values (293, 100, 'General (HW)'); insert into INTEREST values (293, 197, 'Computer architecture'); insert into INTEREST values (293, 365, 'Computer Design'); insert into INTEREST values (293, 425, 'Parallel Computer Architecture'); insert into INTEREST values (293, 443, 'Performance Analysis - Reliability and Fault Tolerance'); insert into INTEREST values (294, 100, 'Control Structures and Microprogramming'); insert into INTEREST values (295, 130, 'Networks'); insert into INTEREST values (296, 168, 'Microcode - Numerical Analysis'); insert into INTEREST values (296, 213, 'TAILORED MICRO-ENGINES - PROGRAMMABLE MICROENGINES'); insert into INTEREST values (296, 440, 'Microcode - Numerical Analysis'); insert into INTEREST values (297, 100, 'Arithmetic and Logic Structures'); insert into INTEREST values (297, 356, null); insert into INTEREST values (297, 357, null); insert into INTEREST values (297, 464, 'Arithmetic and Logic Structures'); insert into INTEREST values (299, 100, 'Memory Structures');