Use arithmetic operators and aggregate functions.Procedure:1. Create a table named StudentGrade with the following columns and values. Set the appropriate datatype for each column.Units GradeCourseCodeCOSC1003CourseTitleData Structures and AlgorithmsReadings in Philippine HistoryPhysical Education 3Rizal's Life and WorksHuman-Computer InteractionObject-Oriented ProgrammingPrinciples of CommunicationPlatform Technology1.50GEDC100632.25PHED100321.25GEDC101431.50COSC1007INTE104431.2531.75COSC100132.25COSC100831.502. Using queries, display the following:a. The number of courses/subjectsb. The total unitsc. 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 divideby the total units.)Expected output: a. 8 b. 23 c. 6 d. 2 e. 1.67

--creating tablecreate table studentgrade(coursecode varchar(30),coursetitle varchar(30),units…

Use arithmetic operators and aggregate functions. Procedure: 1. Create a table named StudentGrade with the following columns and values. Set the appropriate data type for each column. CourseCode CourseTitle Units Grade Data Structures and Algorithms Readings in Philippine History Physical Education 3 COSC1003 3 1.50 GEDC1006 3 2.25 PHED1003 2 1.25 3 1.25 1.75 GEDC1014 Rizal's Life and Works 1.50 COSC1007 3 Human-Computer Interaction Object-Oriented Programming Principles of Communication Platform Technology INTE1044 2.25 COSC1001 COSC1008 1.50 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

Use arithmetic operators and aggregate functions. Procedure: 1. Create a table named StudentGrade with the following columns and values. Set the appropriate data type for each column. CourseCode CourseTitle Units Grade Data Structures and Algorithms Readings in Philippine History Physical Education 3 COSC1003 3 1.50 GEDC1006 3 2.25 PHED1003 2 1.25 3 1.25 1.75 GEDC1014 Rizal's Life and Works 1.50 COSC1007 3 Human-Computer Interaction Object-Oriented Programming Principles of Communication Platform Technology INTE1044 2.25 COSC1001 COSC1008 1.50 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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 2HOA: Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The...

See similar textbooks

Similar questions

Attempt to view the structure of the HOMEWORK13 view.
A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the above
Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438? 3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4. Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?
The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write a SELECT statement to select the year and the total number of movies for that year. Hint: Use the COUNT() function and GROUP BY clause. NOTE: Starter code has been provided. Simply change the blanks ("_") to the appropriate entity/value.
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Delete the following rows: Horse with ID 5. All horses with breed Holsteiner or Paint. All horses born before March 13, 2013. NOTE: Starter code has been provided. Simply change the blanks ("_") to the appropriate entity/value.
Suppose you have a table with a primary key composed of two columns. When another column in this table is dependent on only one of the two columns in the primary key, this poses a risk for _____. a. update anomalies b. functional dependency c. qualification errors d. function splitting
Description The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +--- | Id | Name | Salary | ManagerId | +---- | 1 | 2 | 3 | 4 +---- | Joe | 70000 | 3 | Henry | 80000 | 4 | Sam | Max Given the Employee table, write a SQL query that finds out employees who earn more than their managers. For the above table, Joe is the only employee who earns more than his manager. + | Employee | + | Joe + | 60000 | NULL | 90000 | NULL I
Question 5 Suppose that you have the following table: CREATE TABLE coupons ( coupon id INTEGER name VARCHAR2 (30) duration INTERVAL YEAR (3) TO MONTH Now, considers the following INSERT statement: INSERT INTO coupons (coupon id, name, duration) VALUES (4, 'BD1.5 Corn Flakes, INTERVAL 1- 3 YEAR TO MONTH) The above INSERT statement stores the following data: A. 4 BD1.5 Corn Flakes +000-14 4 BD1.5 Corn Flakes +014-00 4 BD1.5 Corn Flakes +014 None of the above
Create the table Students (sno, sname, dateofbirth, program, cgpa) Fees (sno, date, fee ) Elective (sno, subcode, sub_name) Marks (sno, subcode, marks, grade) Subject ( subcode, subjectname, credit) Constraints (dateofbirth should be less than todays date in student table) (fee can not zero or negative in fee table) (Credits can not be zero or less in subject table) Query List the name of the student who got maximum cgpa. List the maximum, average and minimum CGPA for every program List the name of students who have choosed 4 credit subject List the total fee paid by every students
1-Write the syntax to insert into a relational table called students the address column references an object table called addresses that was created using an address_type. Other columns exist in the students table, but you are only inserting into the ones below. Aliases used should be the first letter of the table name, eg students would be s, addresses would be a Relational Table Name students attribute student_id attribute surname attribute address