MIS 562 MIS562 MIS/562 ENTIRE COURSE HELP – DEVRY UNIVERSITY
MIS 562 Lab 7 in MySQL
For Part 1 Q1, you don’t need to run SQL and no output is required.
For Part 1 Q2, be sure to include output
For part 2 running stored procedure, please refer to document under Announcement. You must include output for all three questions
Part 1
Question SQL statement or Answer
Analyze the following query and write a description of the output it produces. (20 points)
Do not run query.
1
2
3
4
5
6
7
8
SELECT COUNT(DECODE(SIGN(total_capacity-20), -1, 1, 0, 1)) “<=20",
COUNT(DECODE(SIGN(total_capacity-21), 0, 1, -1, NULL,
DECODE(SIGN(total_capacity-30), -1, 1)))"21-30",
COUNT(DECODE(SIGN(total_capacity-30), 1, 1)) "31+"
FROM
(SELECT SUM(capacity) total_capacity, course_no
FROM section
GROUP BY course_no)
You don’t need to execute SQL Query and you
https://www.solvedcollegepapers.com/product/mis-562-mis562-mis-562-dev
https://www.solvedcollegepapers.com/product/mis-582-mis582-mis-582-dev
