Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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, 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started