Part I. B) For the TEMP_STUDENT table created above, write insert statements tha

Question

Part I.

B) For the TEMP_STUDENT table created above, write insert statements that

violate each of the constraints. Write 3 insert statements that succeed when executed.

3. Show all the different companies for which students work. Display only companies where more than four students are employed.

4. Determine the highest grade achieved for the midterm for each section.

5. Display all the sections where classes start at 10:30 A.M.

6. Write the query to accomplish the following result. The output shows you all the days of the week where sections 83, 86, 107 starts. Note the order of the days.

DAY                                        SECTION_ID

-------                                    ------------------

Mon                                                      107

Tue                                                        86

Wed                                                      83

7. Select the distinct course costs of all the courses. If the course cost is unknown, substitute a zero. Format the output with a leading $ sign and separate the thousands with a comma. Display two digits after the decimal point. The cost should be in ascending order. The output should look like the following:

COST

-------------

        $0.00

$1,000.00

Explanation / Answer

3)

SELECT employer, COUNT(*)
FROM student
GROUP BY employer
HAVING COUNT(*) > 4
EMPLOYER COUNT(*)
-------------------- ---------
Amer.Legal Systems 10
Crane Co. 6
Electronic Engineers 15
New York Pop 8

4 rows selected.

4)

5)

6)

7)

or:

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.