--8**)Students who enrolled in more than 5 courses Spring semester 2005**

select fname,CourseName,count(d.courseid),b.enrollmentdate,semester from tstudent a

join tStudentCourseMap b

on a.studentID=b.StudentID

join tcourses c

on c.courseid=b.CourseID

...

Ty again. i don't want the whole query myself ..i just want to know my mistakes and improve my concepts.

list of students with the number of courses they...

Thank You...Again this is not homework..If you want i can't send you all the 15 questions but we are not suppose to give as homework..we are suppose to practise it...

This is one of the practise question i didn't get the output for ..we will discuss in next class. ty

My tables are:

1. tstudent

Create table tstudent

(

studentID int identity (1,1),

Fname varchar(50),

Lname varchar(50),

Sex char(1),

JoinDate date,

Address varchar(100),

[Email-ID] varchar(50),

Contact varchar(25)

)

2.tcourses

create table tcourses

(

courseid int primary key,

CourseName varchar(50),

Credits int,

Fees money,

Semester varchar(50)

)

3.tstudentcoursemap

(

StudentID int, --...

Thank You everyone (JEFF,Lynn,Andre and all),

i just started the Advanced select topic and "join" function and it's just getting harder...i was able to fix...

The person i am taking the class came up with the project and the question but again it is for practice and we would discuss it in the next class...

well the guy i am taking class with gave the project and the question but i am not suppose to answer and submit it as a homework..i am suppose...

For question 5, ......i am doing something wrong and i cant figure it out...it gives me null(blank Values)...is my mapping wrong or my queries...i am just starting with...

sry to not have provided the query..i am doing something wrong coz when i joined do the second join i get blank but when i check the mapping its' correct..it's...

sry to not have provided the query..i am doing something wrong coz when i joined do the second join i get blank but when i check the mapping its' correct..thank...

sry to not have provided the query..i am doing something wrong coz when i joined do the second join i get blank but when i check the mapping its' correct..it's...