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

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4CAT: Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be...

See similar textbooks

Similar questions

Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be able to retrieve data from the TRIP table. b. Users Gomez and Liston must be able to add new reservations and customers to thedatabase. c. Users Andrews and Zimmer must be able to change the price of any trip. d. All users must be able to retrieve the trip name, start location, distance, and type forevery trip. e. User Golden must be able to add and delete guides. f. User Andrews must be able to create an index for the TRIP table. g. Users Andrews and Golden must be able to change the structure of the CUSTOMERtable. h. User Golden must have all privileges on the TRIP, GUIDE, and TRIP_GUIDEStables.
Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table.
Create a MYSQL Database named 'db'Create a MYSQL User named 'dbuser' with a password 'dbpass' Grant Insert, Delete, Update and Select privileges for 'dbuser' on 'db' Create a MYSQL Table on database 'db' and name it as 'students' with the following field and field propertiesField Name Field Type Field Size Additional İnformationStudent No Varchar 6 Primary keyName Varchar 20 Surname Varchar 25 birthdate date
ASAP!! Create a New ASP.NET MVC Web application. Create a New Database in App_Data FolderWPLTASKDB. Create Three Tables in your DatabaseCustomer ->ID (PK), Name, DOB,EmailProduct->Id(PK),Price, ExpiryDateOrder -> ID (PK), Date, CustomerIdOrderDetails - > OrderId(PK), ProductID(PK), OrderedQuantityCreate Three Controller in your Website,• Customer Controller your Application should be able to Add, Update, Delete and View All Customer • Product Controller your Application should be able to Add, Update, Delete and View AllProduct• Order Controller your Application should be able to Add, Update, Delete and View AllOrders.
1. Login / Database connectivity 2. Session (security) 3. CRUD - creating/displaying, recording, updating, and deleting records in the database note: import the database file staffinventorydb.sql in the phpmyadmin portal
Please solve the error in the PostgreSQL query. Thank you CREATE TABLE IF NOT EXISTS "basefiles" ("fileuuid" TEXT,"flocation" TEXT NOT NULL UNIQUE,"scannedby" TEXT DEFAULT 'mdvine', "scannedwhen" timestamp DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY("fileuuid")); INSERT INTO basefiles VALUES ('puwr', 'pubty', 'fdf', 10:52);select * from basefiles
134. EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table? a. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234; b. DELETE FROM empdetWHERE ename LIKE 'J%'; c. CREATE VIEW empvuASSELECT * FROM empdept; d. CREATE INDEXempdet_idxON empdet(empno);
Hello can you help me to connect my registration PHP which I don't know how to insert those registration data on my database and table which is the admin table and the regular table. Can you help me for the right code for the table admin and regular to connect to my database I would appreciate if you would put the right code and SQL query for the connection. Here is my PHP code <?php session_start(); include 'database_connection.php'; if($_POST['uname'] && $_POST['password']) { $name=$_POST['name']; $lname = $_POST['lname']; $fname = $_POST['fname']; $mname = $_POST['mname']; $gen = $_POST['gender']; $birth = $_POST['birth']; $type = $_POST['utype']; $email = $_POST['email']; $pass=$_POST['password']; if($type=='Admin') admin($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con); else regular($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con); }…
Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a database and name it MyFirstDatabase. Create two tables name Biodata and Contacts, choosing column names, datatypes primary keys and foreign key to link to tables. Insert twenty (20) into each table Take screenshot of the two tables, each showing all the records and save in a folder (Your name followed by index number). Obtain the ER diagram and save it in the above folder.(PLEASE INCLUDE THE STEPS)
IN MYSQL in DBA oracel Create a user with the name IS Sead and password a789 and give him permission to connect to the databaseCreate a role function that includes allowing to create a table and create a view and then granting that function to the Sead . user Make the sead user give permission to query and enter on the student table for all users in the databaseHave the user sead withdraw the entry on the student table from user saa
For all Questions in this Formative, paste full screenshots of your Microsoft SQL Server Management Studio, showing object explorer, query and query results. To complete all the questions download and restore the TSQLV4 Database in your Microsoft SQL Server Management Studio. Write a query against the Sales.Orders table that returns orders placed in June 2015.
Update you’re the database created in week5: lab5. Write some MYSQL code to select three different sets of data and display them on the screen. Also, delete two different records from any of the table in your the database and then print the remaining data on the screen. Finally, update one of your table with five more new rows of data and print the result of the table on the screen. Detail prior database below. Create the table StudentInf: CREATE TABLE StudentInf (rollNo INT(4) PRIMARY KEY,first_Name VARCHAR(50) NOT NULL,last_Name VARCHAR(50) NOT NULL,gender VARCHAR(10),course VARCHAR(50)); Inserting data in StudentInf table: INSERT INTO StudentInf VALUES (101, 'TONY', 'ANDREW', 'Male', 'JAVA'); INSERT INTO StudentInf VALUES (102, 'JOHN', 'MARTIS', 'Male', 'PHP'); INSERT INTO StudentInf VALUES (103, 'SWEETIE', 'JOHNSON', 'Female', 'C#'); INSERT INTO StudentInf VALUES (104, 'JIM', 'WATSON', 'Male', 'PYTHON'); INSERT INTO StudentInf VALUES (105, 'BRUCE', 'DOWNEY', 'Male', 'PHP');…