Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please give the code in MYSQL g Auto ALL o 6. Advertising System Net Seller Report As part of HackerAd's advertising system analytics, a team
Please give the code in MYSQL
g Auto ALL o 6. Advertising System Net Seller Report As part of HackerAd's advertising system analytics, a team needs a list of campaigns that have a sequence of events with more sell transactions than buy transactions. Transactions arexonsidered in the order they appear in the table. A sequence is a number of consecutive transactions with the same campaign_id. The result should be in the following format: campaign, netse//s_count, netse//s total. campaign is the campaign name. A campaign name may have more than one campaign id. netsells_countis the total number of reported event sequences for a campaign name. netse//s_tota/is a total of all the sell transactions in event sequences. Results should be sorted descending by netse//s_tota/. Schema Sample Data Tables 20 21 22 23 24 26 28 29 s AS AS 30 31 33 34 ENC FRO v' GRO v Quan 6 7
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started