1 4 Points Professor Crewel Would Like To See The Distribution Of Questions Difficul 2379462
1. (4 points) Professor Crewel would like to see the distribution of questions difficulty among the various topics.
For each question list the topic title, the question id, the questions status, and the question difficulty. Sort the results for question difficulty. Within question difficulty sort the questions by topic title. Use a join. Do not use the INNER JOIN keywords.
SELECT A. Title, B. QuestionId, B. Status, B. Difficulty from Topics A., Question B WHERE
A. Topicid =B. Topicid ORDER BY B. Difficulty, A. Title how do u show The result of the SELECT statement
Document Preview:
CITD 120 — SQL Concepts Homework Assignment 4 40 points NOTE: The Course Quizzes database you are using for this assignment is a test database and contains much less data than would be in the production database used to run the company. It has been made smaller to make it easier for you to check that your SELECT statement retrieves the correct data. However, retrieving the correct data from the testing database is not a guarantee that the SELECT statement is correct. You must write your commands as if they were run against the larger database which has different data than the testing database you are using. The ER Diagram for the Course Quizzes database is shown below. For EACH TASK for this assignment submit the following: a. The SELECT statement you used. b. The result of the SELECT statement. TASKS: (4 points) Professor Crewel would like to see the distribution of questions difficulty among the various topics.For each question list the topic title, the question id, the questions status, and the question difficulty. Sort the results for question difficulty. Within question difficulty sort the questions by topic title. Use a join. Do not use the INNER JOIN keywords. SELECT A. Title, B. QuestionId, B. Status, B. Difficulty from Topics A., Question B WHERE A. Topicid =B. Topicid ORDER BY B. Difficulty, A. Title 2.(4 points) Professor Crewel would like to know the text of the questions she has used on quiz 2.List the question text for the questions for quiz 2. Do not use a join. Use the IN operator. SELECT Text FROM Questions WHERE QuestionId in (SELECT QuesionId from QuizQuestionns WHERE QuizNum = 2) 3.(4 points) Professor Crewel would like to know which questions she has used on quiz 2.List the question text for the questions for quiz 2. Do not use a join. Use the EXISTS operator. SELECT Text FROM QuestionQ WHERE EXISTS ( SELECT* FROM QuizQuestionsQQ …
Attachments:
CITD120Assign….docx
CourseQuiz1–….zip
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
