Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
You are in the Marketing Department and are reviewing sales of coffee and espresso products. You are developing a new marketing campaign and need to know where the customers who purchase these products live. Develop a query to include these attributes in this order: the product name, the sales ship-to country, and the number of cities that each product has been shipped to. Use the AS keyword to temporarily rename the ship-to country attribute as "Country," the product name as "Product," and name the aggregate column as "Number of Cities." You want to include only coffee and espresso products. Add restrictions to the query output in this order: product names that include the pattern "coffee" and product names that end with the pattern "espresso." Sort the query output by "Product" and then by “Number of Cities." The output of this query will become the Coffee Products report.

You are in the Marketing Department and are reviewing sales of coffee and espresso products. You are developing a new marketing campaign and need to know where the customers who purchase these products live. Develop a query to include these attributes in this order: the product name, the sales ship-to country, and the number of cities that each product has been shipped to. Use the AS keyword to temporarily rename the ship-to country attribute as "Country," the product name as "Product," and name the aggregate column as "Number of Cities." You want to include only coffee and espresso products. Add restrictions to the query output in this order: product names that include the pattern "coffee" and product names that end with the pattern "espresso." Sort the query output by "Product" and then by “Number of Cities." The output of this query will become the Coffee Products report.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
You are in the Marketing Department and are reviewing sales of coffee and espresso products. You are developing a new marketing campaign and need to know where the customers who purchase these products live. Develop a query to include these attributes in this order: the product name, the sales ship-to country, and the number of cities that each product has been shipped to. Use the AS keyword to temporarily rename the ship-to country attribute as "Country," the product name as "Product," and name the aggregate column as “Number of Cities." You want to include only coffee and espresso products. Add restrictions to the query output in this order: product names that include the pattern "coffee" and product names that end with the pattern "espresso." Sort the query output by "Product" and then by “Number of Cities." The output of this query will become the Coffee Products report. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Product.ProdName AS "Product", Sale.ShipToCountry AS "Country", COUNT (Sale. ShipToCity ) AS "Number of Cities" FROM (Sale JOIN SaleProduct ON Sale. SalelD Sale ShipToCountry ) JOIN Product ON Product PodID =Product. ProdName WHERE "Product" LIKE "%coffee%" AND "Product" LIKE "%espresso" GROUP BY "Product", "Country" ORDER BY "Product" , "Number of Cities" %3D
Transcribed Image Text:You are in the Marketing Department and are reviewing sales of coffee and espresso products. You are developing a new marketing campaign and need to know where the customers who purchase these products live. Develop a query to include these attributes in this order: the product name, the sales ship-to country, and the number of cities that each product has been shipped to. Use the AS keyword to temporarily rename the ship-to country attribute as "Country," the product name as "Product," and name the aggregate column as “Number of Cities." You want to include only coffee and espresso products. Add restrictions to the query output in this order: product names that include the pattern "coffee" and product names that end with the pattern "espresso." Sort the query output by "Product" and then by “Number of Cities." The output of this query will become the Coffee Products report. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Product.ProdName AS "Product", Sale.ShipToCountry AS "Country", COUNT (Sale. ShipToCity ) AS "Number of Cities" FROM (Sale JOIN SaleProduct ON Sale. SalelD Sale ShipToCountry ) JOIN Product ON Product PodID =Product. ProdName WHERE "Product" LIKE "%coffee%" AND "Product" LIKE "%espresso" GROUP BY "Product", "Country" ORDER BY "Product" , "Number of Cities" %3D
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS