Question: SQL This database has 3 tables Student(StudentID, Name, BirthDate, Address, GPA) Course(CourseID, Name, StartDate, EndDate, Credit, Instructor) Registration(StudentID, CourseID, LetterGrade) Write SQL queries for following

SQL

This database has 3 tables Student(StudentID, Name, BirthDate, Address, GPA) Course(CourseID, Name, StartDate, EndDate, Credit, Instructor) Registration(StudentID, CourseID, LetterGrade)

Write SQL queries for following tasks:

- List all students received grade `A` in that course - List each grade and the number of students receiving that grade in that course (i.e. how many students get an `A`, how many students get a `B`...) - List each course and its number of registered students sorted descendingly - List each instructor with the number of courses he/she has taught and their total credits - List all instructors who teaches large classes (i.e. at least a course with at least 50 students) - List each student with the number of courses he/she has registered and their total credits

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write the SQL Queries for the following tasks using these tables Student(StudentID, Name, BirthDate, Address, GPA) Course(CourseID, Name, StartDate, EndDate, Credit, Instructor)...

SQL Homework Create a single script to do all of the following. Be sure to create in such a way that it can be re-run multiple times. Create a database named homework. In this database, create three...

/*Please answer the Queries and display the code and output.*/ This assignment focuses on the use of the aggregate functions. These functions combine all the results to perform a statistical...

BYGB/ISGB 7973: ASSIGNMENT 2 DATABASE MANAGEMENT SQL Assignment Part I You may want to use the CreateTable_TG.ddl that we used for the TradeGroup an exemplar for this question. This exercise is based...

) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_ Queries (where...

Apex Oracle SQL Queries -- CREATING EACH TABLE IN THE ACADEMIC DATABASE CREATE TABLE ACADEMIC_SESSION ( SESSION_ID NUMBER NOT NULL , SESSION_NAME VARCHAR2(50) ) ; CREATE TABLE COURSE ( COURSE_ID...

use SQL commands to create a database named EduData which is composed of the following tables. Once completed, save the SQL script as a . sql file. TABLES: Students student _ id student _ name...

Query 1 Student table CREATE TABLE Students ( student_id int, name varchar(255) not null , date_of_birth date, address varchar(255), email varchar(255) unique, level varchar(255) not null ,...

With the following database design, write the following 3 queries please..... 1. Students' enrollments per term, sorted by student, term, and course, including student addresses. 2. Instructors'...

oracle sql statement help. I will upvote a clear, detailed response. Thank you!! more joins (inner and outer), subqueries and other SQL issues You are suggested to adopt a user friendly prefix string...

The probability density function of a continuous random variable is given by f(x) = 1 e 1o* for [0, 0). 10 a) Find P(X>3). b) Find the mean of X.

The following are recent excerpts from the financial statements of Sirius Satellite Radio Inc., a company delivering national satellite audio entertainment services: a. Estimate the average useful...

What must Twitter do to keep expanding? Provide more ads for stockholders. Increase add revenue. Continue to make significant investments. Improve cash flow.

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

9. How does training differ between companies that are considered BEST Award winners and those that are not?

6. Which of the training professionals roles do you believe is most difficult to learn? Which is easiest?

6. Identify appropriate resources (e.g., journals, Web sites) for learning about training research and practice.