Haven't found the Essay You Want?
GET YOUR CUSTOM ESSAY SAMPLE
For Only $12.90/page

Prime number Essay

A4 – Intermediate Queries Assignment 4 1. CREATE AN ORACLE TABLE FOR THE FOLLOWING STUDENT DATA: STUDENT Name ID Major CourseAssignment 1Assignment 2Midterm Final Project Aisha Ahmed 200312345 CIT CIT365 83 91 77 82 71 Anood Abdulla 20031235 6 BUS CIT365 77 81 66 76 81 Budoor Mahommad 20033312 3 EDC CIT365 91 79 92 88 91 Fatma Essa 20031452 1 CIT CIT365 66 55 60 73 69 Ghulood Ali 20031121 1 CIT CIT365 58 72 88 81 88 Hanan Ahmed 20036121 2 BUS CIT365 100 92 90 91 95 Hanan Abdulla 20041212 1 CIT CIT365 93 88 83 81 83 Laila Saeed 20027123 4 EDC CIT365 67 72 78 74 81 Maryam Ibrahim 20031991.

1 CIT CIT365 82 86 84 91 93 Shamsa Khalid 20038634 1 BUS CIT365 89 96 92 98 92 CREATE TABLE STUDENTS ( ID DECIMAL(9), NAME VARCHAR(20), MAJOR CHAR(3), COURSE VARCHAR(6), A1DECIMAL(3), A2DECIMAL(3), MIDTERM DECIMAL(3), FINAL DECIMAL(3), PROJECT DECIMAL(3), PRIMARY KEY(NUMBER)); A4 – Intermediate Queries 2. CREATE INSERT STATEMENTS TO ENTER THE DATA INTO YOUR TABLE. WRITE QUERIES TO ANSWER THE FOLLOWING: INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200312345,’AISHA AHMED’,’CIT’,’CIT365′,83,91,77,82,71); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT).

VALUES (200312356,’ANOOD ABDULLA’,’BUS’,’CIT365′,77,81,66,76,81); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200333123,’BUDOOR MAJOMMED’,’EDC’,’CIT365′,91,79,92,88,91); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200314521,’FATMA ESSA’,’CIT’,’CIT365′,66,55,60,73,69); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200311211,’GHULOOD ALI’,’CIT’,’CIT365′,58,72,88,81,88); INSERT INTO STUDENTS A4 – Intermediate Queries (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT)

VALUES (200361212,’HANAN AHMED’,’BUS’,’CIT365′,100,92,90,91,95); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200412121,’HANAN ABDULLA’,’CIT’,’CIT365′,93,88,83,81,83); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200271234,’LAILA SAEED’,’EDC’,’CIT365′,67,72,78,74,81); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200319911,’MARYAM IBRAHIM’,’CIT’,’CIT365′,82,86,84,91,93); INSERT INTO STUDENTS (ID,NAME,MAJOR,COURSE,A1,A2,MIDTERM,FINAL,PROJECT) VALUES (200386341,’SHAMSA KHALID’,’BUS’,’CIT365′,89,96,92,98,92);

3. HOW MANY STUDENTS ARE THERE IN THE COURSE? SELECT * FROM STUDENTS WHERE COURSE=’CIT365′; +———–+—————–+——-+——–+——+——+———+——-+ ———+ | ID | NAME | MAJOR | COURSE | A1 | A2 | MIDTERM | FINAL | PROJECT | +———–+—————–+——-+——–+——+——+———+——-+ A4 – Intermediate Queries ———+ | 200271234 | LAILA SAEED | EDC | CIT365 | 67 | 72 | 78 | 74 | 81 | | 200311211 | GHULOOD ALI | CIT | CIT365 | 58 | 72 | 88 | 81 | 88 | | 200312345 | AISHA AHMED | CIT | CIT365 | 83 | 91 | 77 | 82 | 71 |.

| 200312356 | ANOOD ABDULLA | BUS | CIT365 | 77 | 81 | 66 | 76 | 81 | | 200314521 | FATMA ESSA | CIT | CIT365 | 66 | 55 | 60 | 73 | 69 | | 200319911 | MARYAM IBRAHIM | CIT | CIT365 | 82 | 86 | 84 | 91 | 93 | | 200333123 | BUDOOR MAHOMMED | EDC | CIT365 | 91 | 79 | 92 | 88 | 91 | | 200361212 | HANAN AHMED | BUS | CIT365 | 100 | 92 | 90 | 91 | 95 | | 200386341 | SHAMSA KHALID | BUS | CIT365 | 89 | 96 | 92 | 98 | 92 | | 200412121 | HANAN ABDULLA | CIT | CIT365 | 93 | 88 | 83 | 81 | 83 | +———–+—————–+——-+——–+——+——+———+——-+ 5. WHICH STUDENTS HAVE THE LETTER “S” IN THEIR NAMES?

A4 – Intermediate Queries SELECT NAME FROM STUDENTS WHERE NAME LIKE ‘%S%’; +—————+ | NAME | +—————+ | LAILA SAEED | | AISHA AHMED | | FATMA ESSA | | SHAMSA KHALID | +—————+ 6. LIST THE AVERAGE SCORE FOR EACH STUDENT. ASSUME THAT ALL ASSESSMENTS HAVE EQUAL WEIGHT. SELECT NAME,(A1+A2+MIDTERM+FINAL+PROJECT)/5 AS AVERAGE FROM STUDENTS; +—————–+———+ | NAME | AVERAGE | +—————–+———+ | LAILA SAEED | 74. 4000 | | GHULOOD ALI | 77. 4000 | | AISHA AHMED | 80. 8000 | | ANOOD ABDULLA | 76. 2000 | | FATMA ESSA | 64. 6000 | | MARYAM IBRAHIM | 87.

2000 | | BUDOOR MAHOMMED | 88. 2000 | | HANAN AHMED | 93. 6000 | A4 – Intermediate Queries | SHAMSA KHALID | 93. 4000 | | HANAN ABDULLA | 85. 6000 | +—————–+———+ 7. WHAT IS THE AVERAGE SCORE FOR THE STUDENT WHO SCORED HIGHEST ON THE MIDTERM? SELECT NAME,MAX(MIDTERM),(A1+A2+MIDTERM+FINAL+PROJECT)/5 AS HIGHSTMIDTERMSCOREDSTUDENTSAVERAGE FROM STUDENTS; +————-+————–+————————————+ | NAME | MAX(MIDTERM) | HIGHSTMIDTERMSCOREDSTUDENTSAVERAGE | +————-+————–+————————————+ | LAILA SAEED | 92 | 74.

400000000 | +————-+————–+————————————+ 8. LIST THE DATA SORTED BY MAJOR AND WITHIN MAJOR BY NAME. SELECT MAJOR FROM STUDENTS ORDER BY MAJOR; +——-+ | MAJOR | +——-+ | BUS | | BUS | | BUS | | CIT | | CIT | | CIT | A4 – Intermediate Queries | CIT | | CIT | | EDC | | EDC | +——-+ 9. LIST THOSE STUDENTS WHO SCORED LESS THAN 70 ON ANY ASSESSMENT. SELECT ID,NAME,A1,A2 FROM STUDENTS WHERE (A1< 70) AND (A2<70); +———–+————+——+——+ | ID | NAME | A1 | A2 | +———–+————+——+——+ | 200314521 | FATMA ESSA | 66 | 55 |.

+———–+————+——+——+ 10. LIST THE MAJORS AND THE NUMBER OF STUDENTS IN EACH MAJOR. SELECT MAJOR,COUNT(MAJOR) FROM STUDENTS GROUP BY MAJOR; +——-+————–+ | MAJOR | COUNT(MAJOR) | +——-+————–+ | BUS | 3 | | CIT | 5 | | EDC | 2 | +——-+————–+ 11. LIST THE AVERAGE OVERALL GRADE FOR EACH MAJOR SELECT MAJOR,(A1+A2+MIDTERM+FINAL+PROJECT)/5 AS AVG FROM STUDENTS GROUP A4 – Intermediate Queries BY MAJOR; +——-+———+ | MAJOR | AVG | +——-+———+ | BUS | 76. 2000 | | CIT | 77. 4000 | | EDC | 74. 4000 | +——-+———+


Essay Topics:


Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email. Please, specify your valid email address

We can't stand spam as much as you do No, thanks. I prefer suffering on my own