Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance services an integrated approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan

16th edition

978-0134075754, 134075757, 134065824, 978-0134065823

More Books

Students also viewed these Business Communication questions