You are in the Marketing Department and are reviewing sales of coffee and espresso products. Youare developing a new marketing campaign and need to know where the customers who purchasethese products live. Develop a query to include these attributes in this order: the product name, thesales ship-to country, and the number of cities that each product has been shipped to. Use the ASkeyword 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 coffeeand espresso products. Add restrictions to the query output in this order: product names thatinclude the pattern "coffee" and product names that end with the pattern "espresso." Sort the queryoutput 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 SaleProductON Sale. SalelDSaleShipToCountry) JOIN Product ON ProductPodID=Product.ProdNameWHERE "Product" LIKE"%coffee%"AND"Product"LIKE"%espresso"GROUP BY "Product", "Country"ORDER BY "Product", "Number of Cities"%3D

Explanation: SQL stands for the structured query language To give existent columns a temporary new…

Answered: You are in the Marketing Department and…

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

Similar questions

Display the first 10 rows of the invoice number, 2 line numbers, 2 product SKUs, 2 product descriptions, and brand ID for the sales of “sealer” and “top-coat” related products of the same brand on the same invoice sorted by the invoice number. (See partial result below, it has only 2 rows) Hints: Assign two different alias to both the"lin" and "product" tables. Then do the joins treating them as 4 differnet tables.
Reference table 6-28. Include both SQL commands and results/answers in your answers. In the NONCAT table, increase the price of each item in category BRD by five percent. (Hint: Multiply each price by 1.05.) In the NONCAT table, increase the length of the DESCRIPTION column to 40 characters.
Management is considering closing on Sundays and would like to have a feeling for the kinds of customers that come to the dealership on Sunday. Create a totals query that shows the count of encounters on the Sundays of July 2015—grouped by the credit description held by the customer of the encounter. The Sundays in July of 2015 are the 5th, 12th, 19th, and 26th. Your answer should have two columns (CreditDescription and encounter_count) and should be sorted alphabetically by credit description. This is what Ive been working with and doesn't give me results, just error messages. SELECT R.CreditDescription, E.CustomerID FROM Encounter E JOIN Customer C ON E.CustomerID = C.CustomerID JOIN CreditRating R ON C.CreditID = R.CreditID WHERE E.EncDate = STR_TO_DATE('2015-07-05','2015-07-12','2015-07-19','2015-07-26'); ORDER BY creditrating.creditid, ASC; creditrating creditid creditdescription minfico maxfico comments customer customerid cfirstname clastname…
Prompt: You work in the Procurement Department, and you need a list of select items carried for sale by COB 204 Company and details about the supplier and current stock balance. Develop a query that will produce output with the following attributes in this order: product name, supplier name, and the quantity of product in stock. Restrict the query to include only those products supplied by a supplier whose company name starts with the letter E. Additionally, restrict the query to only those products that currently have a quantity in stock that is greater than or equal to 50. Finally, sort the query output alphabetically by the product name. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Product.ProdName, Supplier.CompanyName, Product. FROM Product Supplier ON Product. |=Supplier. WHERE Supplier. AND Product. 50 ORDER BY Product.ProdName; Query Result Count (enter number only, ex. 12): Result: rows
Create a query to find the balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.22. make sure the decimal are the same
Write a query to display the brand ID, brand name, brand type, and average price of products for the brand that has the largest average product price (Figure P7.46)
Select the query that properly uses table aliases to show the genres of each track in the Album with the id of 6. SELECT genre.name, track.nameFROM trackJOIN genreUSING (genre_id)WHERE track.album_id=6; SELECT g(name), t(name)FROM track AS tJOIN genre AS gUSING (genre_id)WHERE t(album_id)=6; SELECT g.name, t.nameFROM t AS trackJOIN g AS genreUSING (genre_id)WHERE t.album_id=6; SELECT g.name, t.nameFROM track AS tJOIN genre AS gUSING (genre_id)WHERE t.album_id=6;
Question #10.Write a query to retrieve invoice_number, invoice_date, and “Balance Due” from the invoices table.Balance Due can be calculated by subtracting payment and credit from the original invoicedamount. Make sure to only select rows with positive “Balance Due” and sort the results basedon Balance Due. Refer to the sample result screen below.
Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.
Rewrite the following query using a join statement (no subqueries). (0.5) SELECT productid, productname, productprice FROM product WHERE productid IN (SELECT productid FROM soldvia GROUP BY productid HAVING SUM(noofitems) > 3);
Create a view, using JOBS, DEPARTMENTS, and JOB_HISTORY tables that will include department name (not ID), job title (not jobID), start date, and end date for all rows in the JOB_HISTORY table Using your view, write a query that shows the number of rows (count) for each department. Write a query that uses your view from above to select the columns department name, job title, and end date for all rows where the department name includes the string “Sale” that is NOT case-sensitive. Use a function. i.e. SALE, SaLe, Sale, sAle, etc. should all match a row
please answer the below question: Using data below/atached, write a query to find the last_name that is 4th from the bottom using subquery. (you need to use multiple subqueries to get that) and Using data below/attached, write a query to find the third oldest hire date in the table. use this data table:

Recommended textbooks for you

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 Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

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 Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

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

Computer Engineering

ISBN:

9781337093422

Author:

Joy L. Starks, Philip J. Pratt, Mary Z. Last

Publisher:

Cengage Learning

Prelude to Programming

Computer Engineering

ISBN:

9780133750423

Author:

VENIT, Stewart

Publisher:

Pearson Education

Sc Business Data Communications and Networking, T…

Computer Engineering

ISBN:

9781119368830

Author:

FITZGERALD

Publisher:

WILEY

SEE MORE TEXTBOOKS