Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBM11
Starting Member
2 Posts |
 Posted - 2011-12-22 : 12:00:31
|
[UPDATED!]So, I was doing some SQL exercises and I got stuck on these five. Any given help would be greatly appreciated!Alright, so this is how the model looks like in access 2003 These are the questions I haven't been able to solve, despite multiple tries:1) Find information on course occasions that no handicapped students have attended. Show the course code, course name, start date, the room's name and the teacher's name of each of those course occasions.2) Obtain the number of course occasions that each student has attended. Show the student's name and personal code number.3) Show the course-code and price of each course that has been held in at least three different rooms.4) Obtain the number of participating students that are from Kista (a city) by course occasion. Show course code, course name, start date and the number of attending students. Course occasions that do not have any participants from Kista should be shown as well (even though the value is 0).5) Obtain the names, seat capacities and number of course occasions by each room. Obtain the names and capacities of the room that has been used the most number of times.The amount of data in the attributes makes it really difficult to summarize the expected results. Perhaps if anyone would like me to send the database so that you can try it yourself, that would be amazingly appreciated. The database is in English, is not complicated at all, it's just that I'm new to SQL, so I can't figure out how to solve these 5 problems. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2011-12-22 : 13:14:37
|
quote:
Originally posted by DBM11
So i was doing som SQL exercises and i got stuck on these five. I would appreciate any help you can give!Ok this is how the relationship looks like in access 2003 Questions:1) Find information on course occasions that no handicapped student has attended!View course code, course name, start date, the room's name and teacher's name!2) Obtain number of course occasion that each student has attended! View student personal code number, student's name3) Obtain code and price of courses that have been held for at least three different rooms!4) Obtain number of participating students from Kista by course occasion! View course code,course name, start date and number of students! Although course occasion without students from Kista should be included in the results.5) Obtain the names and seat capacities and number of course occasion by room! Obtain the names and capacity of the room that has been used most times! I have started on all of them so if you want i can show how far i have come.
I can't see your picture...wanna post some DDL, sample data (in DML Form) and what your expect results should be?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspxhttp://weblogs.sqlteam.com/brettk/http://brettkaiser.blogspot.com/ |
 |
|
|
DBM11
Starting Member
2 Posts |
Posted - 2011-12-23 : 03:28:06
|
| Hi, Brett, thanks for your response. I've updated my first post! =)Best Regards |
|
|
|
|
|
|
|
|
Need some basic help with SQL in Access 2003