Question: STI Task Performance Report Card Objective: At the end of the exercise, the students should be able to: Use arithmetic operators and aggregate functions

STI Task Performance Report Card Objective: At the end of the exercise,

 

STI Task Performance Report Card Objective: At the end of the exercise, the students should be able to: Use arithmetic operators and aggregate functions Procedure: IT1924 1. Create a table named StudentGrade with the following columns and values. Set the appropriate data type for each column. CourseCode Course Title Units Grade COSC1003 Data Structures and Algorithms 3 1.50 GEDC1006 Readings in Philippine History 3 2.25 PHED1003 Physical Education 3 2 1.25 GEDC1014 Rizal's Life and Works 3 1.50 COSC1007 Human-Computer Interaction INTE1044 COSC1001 COSC1008 mmmm 3 1.25 3 1.75 3 2.25 3 1.50 Object-Oriented Programming Principles of Communication Platform Technology 2. Using queries, display the following: a. The number of courses/subjects b. The total units c. The number of courses with grades higher than 2.00 (lower than 2.00 in the column) d. The number of courses with grades lower than 2.00 (higher than 2.00 in the column) e. The general weighted average (Get the sum of all the products of units and grades, then divide by the total units.) Expected output: a. 8 b. 23 c. 6 d. 2 e. 1.67

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Communication Questions!