Consider the following schema: Message(mId, subject, body), Customer(email, name, householdSize, address), SentTo(mId, email, sendDate).
(a) Write an SQL query that returns all attributes of customers that have household size
greater than one.
(b) Write an SQL query that counts the total number of messages.
(c) Write an SQL query that returns all email addresses and names of customers who have
been sent the message with subject "Spring 2004 Specials".
(a) SELECT *
FROM Customer
WHERE householdSize > 1
(b) SELECT COUNT(*)
FROM Message
(c) SELECT C.email, C.name
FROM Message M, SentTo S, Customer C
WHERE M.subject = 'Spring 2004 Specials' AND M.mId = S.mId
AND S.email = C.email
You might also like to view...
The essence of ________ philosophy is that all participants in creating a product or system should collaborate from the beginning, including business unit managers, developers operations staff, security staff, and end-user groups.
A) ALM B) Develops C) SaaS D) NFV
E-mail messages arrive in your electronic Inbox, where they can be stored for later use.
Answer the following statement true (T) or false (F)
Normalization means that there are no data entry errors in a database
Indicate whether the statement is true or false
The ____ command adjusts the color balance, contrast, and saturation of an image using thumbnail samples.
a. Auto Color b. Variations c. Levels d. Brightness/Contrast