1. Pl Sql Program To Find Sum And Average Of 10 Numbers
2. Pl/sql Function To Calculate Average
3. Write Pl Sql Program To Find Student Grade Using Nested If

C Program to Calculate Grade of StudentHere we write a C program to find grade of student, If percentage is greater than 85% print A grade, If percentage is less than 85% print B grade, If percentage is less than 75 print C grade, If percentage is less than 50 print D grade, If percentage is less than 30 print fail.' Algorithm to Calculate Grade of Student. First Receive Student Marks of each subject. Calculate sum of all subjects marks. divide total marks by number of subject (percentage=total marks / number of subject).

May 26, 2018  I want to calculate grades automatically from a SQL Server database with my query but I'm having a lot of errors. How to calculate student grade with SQL. Ask Question 0. I want to calculate grades automatically from a SQL Server database with my query but I'm having a lot of errors.

If percentage 85 print A grade, If percentage = 75 print B grade, If percentage = 50 print C grade, If percentage 30 && percentage.

I am very 'noob' when it comes to PL/SQL, but I have to specifically write some PL/SQL code (DECLARE/BEGIN/etc.), not just a query.I'm really trying to find one good example that will hopefully let me grasp the rest of the problems. Here's the one I'm currently trying to figure out:Write a PL/SQL program to calculate the total number of credits for each student. NOTE: Courses in which a student gets an F do not count toward credit. If a student retakes a class in which he/she got a low grade, it only counts toward credit one time.

Output should include the studentnum and total credits. Student-schema =(studentnum, name, standing, gpa, major)Class-schema = (schedulenum, semester, department, classnum, days, time, place, enrollment)Instructor-schema = (name, department, office)Teaches-schema = (name, schedulenum, semester)Taking-schema = (studentnum, schedulenum, semester, grade)Here's one of my pathetic attempts: DECLAREstudid student.studentnum%TYPE;total number(10);BEGINFOR count IN (SELECT. FROM taking)LOOPSELECT studentnum, count(.) totalINTO studid, totalWHERE grade = 1;END LOOP;END;/In the one above, idk what I'm doing wrong or right. I get an error 'exact fetch returns more than requested number of rows' at line 1. I had this error before, and thought that the for loop would solve it. Obviously I was wrong. I don't even know how this would successfully output the results even if it did query it correctly.

May 7, 2015 - Usually when a colonist catches fire, they're fairly competent at putting themselves out as long as they're not trapped in a corner or have their. Rimworld colonist editor mod.

Pl Sql Program To Find Sum And Average Of 10 Numbers

I'm so lost, and a little direction WILL go a long way. You need to create sample data, e.g.

Add create table scripts and populate tables with some fake data. In general you need to join Student and Taking (if Taking is total classes student have taken) on studentnum and count takings per student as you are trying to do, but incorrectly. See collapsar example. It calcs totals of takings by student.

You need to add a filter to exclude failing grades, smth like and grade 'F' or grade 0. Also, you need to add class to the query and group by studentnum and class. This is how you'd get distinct class/student count.–Apr 23 '13 at 18:30. The code below iterates over the result set of students and the count of their grades, not counting 'F' grades. The snippet doesn't implement the restriction that no class may contribute more than one grade; however, it should get you started so you can complement the missing pieces. DECLAREstudid student.studentnum%TYPE;total number(10);BEGINFOR i IN (SELECT s.studentnum stud, COUNT(.) cntFROM student sJOIN taking t on ( t.studentnum = s.studentnum )JOIN class c on ( c.schedulenum = t.schedulenum )WHERE t.grade 0GROUP BY s.studentnum) LOOPNULL; - whateverEND LOOP;END;/. S, t and c are table aliases needed in the joins to refer to columns unambiguously; eg, studentnum is defined in student and taking.

Pl/sql Function To Calculate Average

The join would indeed be unnecesaary if all information was in a single relation, but i doubt that. The only candidate would be class (because you need the grades) and there is no field id-ing students in this relation (btw, if there was, you would still miss on all students who did not take any classes at all when limiting yourself to this relation).–Apr 23 '13 at 17:28. I do believe I found a proper solution. None of the answers really worked, so I ended up just making a cursor to go through the data.

Write Pl Sql Program To Find Student Grade Using Nested If

Because of the joins I'm doing, I believe it will filter out duplicate classes taken by the same student: DECLARECURSOR c ISSELECT taking.studentnum, count(.) totalFROM student, taking, classWHERE grade 0AND student.studentnum = taking.studentnumAND taking.schedulenum = class.schedulenumAND taking.semester = class.semesterGROUP BY taking.studentnum;credits c%ROWTYPE;BEGINOPEN c;LOOPFETCH c INTO credits;EXIT WHEN c%NOTFOUND;dbmsoutput.putline('Student#: ' credits.studentnum ' Credits: ' credits.total);END LOOP;END;/.