Please write the SQL to return the sale revenue (top line & bottom line) by Marketing channel for the past 90 days trended by day.Please write the SQL to return the number of visits, visitors and bounce rate for each Marketing Channel for the past 90 days trended by day. (Hint: Bounce rate = Single page view visits / total visits) SAMPLE TABLES AND METADATA:DatabaseValue typeTablesColumnsNotesBI_VISITPrimary Unique Key - ID for individual browsing sessions on websiteID for individuals on websiteEDW_ACCESS_VIEWSVISIT_IDDECIMALEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW ACCESS VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSEDW_ACCESS_VIEWSBI_VISITVISITOR_IDDECIMALBI_VISITBI VISITBI VISITVISIT_DTDATEDate of visit to websiteDECIMALCampaign ID for the first webpage a visit views. The campain that drove the visitor to view the website.A count of pages viewed in a given visitFIRST_PAGE_VIEW_CAMPAIGN_IDPAGE_VIEW_COUNTINTEGERBI_SALESBI_SALESBI_SALESBI SALESSALES_TANSACTION_IDINTEGERID for individual sale transactionsSALES_TRANSACTION_LINE_IDINTEGERPrimary Unique Key - ID for individual items purchased in a sale transactionSALES_TAANSACTION_CAMPAIGN_ID DECIMALREVENUE_TOP_LINEThe last campaign a visit clicked through before the given transactionDECIMALTop line revenue for a transactionBI_SALESBI_SALESBI_SALESBI SALESREVENUE_BOTTOM_LINEDECIMALBottom line revenue for a transactionID for individual browsing sessions on websiteID for item purchasedVISIT_IDDECIMALPRODUCT_IDDECIMALDEPARTMENTSMALLINTDepartment of the product in a given transactionDate of saleBI_SALESBI CAMPAIGN DESCRIPTION CAMPAIGN IDSALES_TRANSACTION_DATEDATEDECIMALPrimary Unique Key - Campaign ID for each marketing campaign runBI_CAMPAIGN_DESCRIPTION CAMPAIGN_DESCRIPTIONVARCHARDescription of the campaignBI CAMPAIGN DESCRIPTION CHANNEL DESCRIPTIONVARCHARMarketing channel the cammpaign belongs to2. Please write the SQL to return the sale revenue (top line & bottom line) by Marketing channel for the past 90 days trended by day.

Here have to determine about sql query for given problem statements.

Please write the SQL to return the sale revenue (top line & bottom line) by Marketing channel for the past 90 days trended by day. Please write the SQL to return the number of visits, visitors and bounce rate for each Marketing Channel for the past 90 days trended by day. (Hint: Bounce rate

Please write the SQL to return the sale revenue (top line & bottom line) by Marketing channel for the past 90 days trended by day. Please write the SQL to return the number of visits, visitors and bounce rate for each Marketing Channel for the past 90 days trended by day. (Hint: Bounce rate

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

4) Display the firstname, lastname of the employees and the customerID that the employee served. Arrange the results by the last name. 5) Write a query to the Name of the Product and the corresponding name of the supplier of that Product for all the products that start with a “P”. 6) Write a SQL query to output the product name and the quantity of the Orders of that product for those orders with more than 70 quantity. (hint: don’t have to use GROUP BY) I need help figuring out the SQL quereys for the questions above using table joining method
This is in sql. For all artists who are currently in a band: Return the artist’s full name (as a single value), the band name, and how long in years the artist has been in the band. The artist should only be shown once for each band. (Hint: Remember that the data might include an artist who left a band and then rejoined. That is the challenge here!) Tables with values are in image.
Using SQL: List the title_name and book type of books that have the lowest royalty rate.
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.
Write SQL CODE List all the Course Code (CRS_CODE) that are taught by a Professor that does not hold "Ph.D." as the highest degree (based on PROF_HIGH_DEGREE in the PROFESSOR table).
Use SQL and TAL Distributors database to complete the following questions:List the customer number and name for all customers located in the city of Grove. Your query should ignore case. For example, a customer with the city Grove should be included as should customers whose city is GROVE, grove, GrOvE, and so on.
Include both SQL commands and SQL results in your answers: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is placed. List the invoice number, customer ID, customer first and last names, and the promotion date for each invoice. The promotion date is 20 days after the invoice was placed. Write PL/SQL (or MySQL) procedures to accomplish the following task: The procedure accepts the ID of a customer stored in the input variable named I_CUST_ID and displays the name (first name concatenated with last name) and credit limit of for this customer.