CIS336 Discussions Week 6

$9.00

CIS336 Discussions Week 6
What are some examples of group functions, and how do they differ from single-row functions? Discuss differences…

 

Description

CIS336 Discussions Week 6

CIS336 Discussions Week 6

All Students Post 83 Pages 

How Group Functions Differ From Single-Row Functions – 38 Pages 

What are some examples of group functions, and how do they differ from single-row functions? Discuss differences between SUM and COUNT. What be the expected results if the following SQL statements are executed?

SELECT retail

FROM books, publisher

WHERE books.pubid = publisher.pubid and publishername = ‘PRINTING IS US’;

 UPDATE books

SET retail = (retail * 1.05)

WHERE pubid =

    (SELECT pubid

     FROM publisher

     WHERE publishername = ‘PRINTING IS US’);

 SELECT retail

FROM books, publisher

WHERE books.pubid = publisher.pubid and publishername = ‘PRINTING IS US’;

What is the purpose for using HAVING clause? What’s the difference between the TO_CHAR and TO_DATE functions when working with date values?…

Lab Forum – 45 Pages

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab. MySQL will allow you to increase, but not decrease the size of a column; however, if the system you are working on allows you to make changes to the column width without restrictions, what would happen to a customer first name field that went from 20 characters to eight characters? If this is not a primary key, does it matter? What is the difference between DROP, TRUNCATE, and DELETE? How about some examples to contrast DROP, TRUNCATE and DELETE? What is the purpose for the HAVING clause in MySQL?  How about enlighten us with an SQL examples that include the HAVING clause?…