|
sql problems!!
i didnt really know which section to post this is, so i thought i'd post it here.
I have an assignment where i have to write sql statements from questions given by the lecturer, i'm really stuck on a couple of Qs:
Database:
Tables:
Team(team_name, competitor_no)
Competitor(competitor_no, competitor_name, team_name)
Quiz(quiz_no, competitor_no, question_no, competitor_answer)
Question_bank(questtion_no, question_text, Correct_answer, section)
This is the question....
"Lost any section where all questions belonging to that section have been used in a quiz."
I must represent the above statement using sql....this is what i have done so far:
Select: section
From: Question_bank
Where: (quiz.Question_no -(minus) question_bank.question_no.......
am i on the right tracks? how can i talk about relating sections to question numbers seeing as though the section is the desired outcome but is not present in the quiz table?
I am really clueless about this one, do u know any good sql sites that might help me with the problem???
|