Skip to content

Latest commit

 

History

History
44 lines (30 loc) · 2.11 KB

sql.md

File metadata and controls

44 lines (30 loc) · 2.11 KB
Raw

  1. How many tables are in this database?

    • There are 16 tables in this database.

  2. How many users are currently set up?

    • There are 222 users currently set up.

  3. Which table has the smallest number of entries? How many entries does it have?

    • lambda_assoc and lambda_questions have the smallest number of entries, which is 1.

  4. How many answers have been posted for multiple choice questions?

    • There are 5487 answers posted for multiple choice questions.

  5. How many quizzes were given to section 6 of CSCI 1320 in Fall 2015?

    • 22 quizzes were given to section 6 of CSCI 1320 in Fall 2015.

  6. Which course has the most quizzes? How many quizzes does it have?

    • Course CSCI1320-5 in Fall 2016 has the most quizzes. The number of quizzes is 26.

  7. Which course has the most questions on quizzes? How many questions does it have?

    • CSCI1321-F16 section 1 has the most number of questions on quizzes. It has 65.

  8. What fraction of students who submit an answer for a function question eventually get it right?

    • 71.69% of students who submit an answer for a function question eventually get it right.

  9. How many courses have given questions of the "lambda" type?

    • 9 courses have given questions of the lambda type.

  10. Which user, by userid, has the most correct answers? How many do they have?

  • User with user id 156 has the most number of correct answers (total from both multiple choice answers and coding answers). It is 126.
  1. What are the three most common spec_types for variables in the problems?
  • The three most common spec_types are 0, 2 and 3. They are 13, 6, 5 of them respectively.
  1. What fraction of quizzes have coding questions?
  • 38.18% of the quizzes have coding questions.
  1. What is the average number of multiple choice questions per quiz?
  • The average number of multiple choice questions is 2.0182.
  1. What is the average number of coding questions per quiz?
  • The average number of coding questions are 0.7636 per quiz.
  1. What is the most attempts per student for any course on any quiz?
  • The most attempts is 212, made by student with user id 58 on quiz id 47.