Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. [4 Pts.] List the names, ids and major of students who are majored in Computer Engineering (CE) 2. [4 Pts.] List the names, ids,
1. [4 Pts.] List the names, ids and major of students who are majored in Computer Engineering (CE) 2. [4 Pts.] List the names, ids, major and gpa of students who have GPA > 3.5 3. [4 Pts.] List the grades of student 'David' with this format: 4. [4 Pts.] List the grade of students who passed the course id "CPS510" with this format: 5. [4 Pts.] Update the grade of all students who passed the course id 'CPS510' section '25' to '4' and list the result 6. [4 Pts.] List all attributes of students who are enrolled in course id 'CS510' with Professor 'Smith', grouped by the course section 7. [4 Pts.] List the student id, student name, course id and course name for all students enrolled in Fall 2021; sort the output in ascending order by student id 8. [4 Pts.] List all professor names who teach a course in winter 2022, along with their course names 9. [4 Pts.] List the name, id, major, degree, and gpa of all students who have a GPA _ 3.0 and studying toward degree 'B.Sc' or 'B.A' 10. [4 Pts.] List the name, id, major, degree, and gpa of all students who have GPA between 3.0 and 4.0 inclusively
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