September 30, 2013 at 8:40 am
two tables
table1 table2
StudentId studentid
TestId teacherid
QuestionId classid
PointsAchieved
PointsPossible
Write a query that would return teachers who’s students had highest overall percent correct on 10 questions with lowest overall percent correct. Percent correct is points achieved/points possible.
September 30, 2013 at 8:48 am
nikonlens50 (9/30/2013)
two tablestable1 table2
StudentId studentid
TestId teacherid
QuestionId classid
PointsAchieved
PointsPossible
Write a query that would return teachers who’s students had highest overall percent correct on 10 questions with lowest overall percent correct. Percent correct is points achieved/points possible.
This looks a lot like homework. We can help guide you but people around don't like to hand out answers, we like to help people learn and understand how to do this.
Also, before anybody can begin helping with code we need details to work with. The first link in my signature explains best practices when posting questions.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply