Print the names and majors of students who are taking one

Question

In this assignment, you will use the data from the previous assignments. You are required to develop the SQL queries for the following:

1. Print the names and majors of students who are taking one of the College Geometry courses. (Hint: You'll need to use the "like" predicate and the string matching character in your query.)

2. For those departments that have no majors taking a College Geometry course, print the department name and the number of PhD students in the department.

Answer 1

This assessment including the major quires regarding the SQL and required to enlarge it more. In the given assignment, you will employ the data from the preceding assignments. You are needed to expand the SQL queries for the subsequent: 1. Publish the majors of students and names who are taking one of the academy Geometry lessons. (Suggestion: You will require using the ‘like’ predicate and the thread matching quality in your doubt.) 2. For those departments which have no mains taking a College Geometry course, publish the number of PhD students in the department and department name Complete the whole quires with best examples.