Listnbsp all the student id and teacher id where gpa is 3


The Assignment:

Consider the tables given below:

TEACHER (teacherId,T_name,T_address,T_phoneNo,Hometown)

STUDENT (studentId,teacherId,S_name,S_address,S_phoneNo,DOB)    

COURSE (couseCode,CourseName,CreditHours)

STUDENT_COURSE (teacherId,studentId,GPA)

Write SQL queries for the following:

List the teachers showing only the Name and Hometown.

List  all the student Id and teacher Id   where GPA is 3 or more than 3.

List all the students of the teacher whose name is 'John Eric'.

List student Id, name, and address of all the students whose date of birth is 1983.

List all the Course Code  where the credit hours are 4

Objective

  • This assignment has been designed so that you understand the concept of SQL

Solution Preview :

Prepared by a verified Expert
Business Management: Listnbsp all the student id and teacher id where gpa is 3
Reference No:- TGS01383567

Now Priced at $10 (50% Discount)

Recommended (95%)

Rated (4.7/5)