Concluído

write a query to generate the following report -- 2

My budget is 50 dollars for having it work . This is a very simple query.

___________________________________________________________________________________________________________

Simple Explanation of the Query needed (instead of candies , in our production Biq Query container we have marketing leads with email as the main attribute. Just using Candy to make a simple analogy. Kids represent marketing partners )

_______________________________________

Five kids (or more) combined their candy collection and store it in a candy Jar ( biq query container).    At the end of month we need to generate two reports.

Report 1. types of candies (email) and the kids who have this type of candies.

Report 2.   kid and type of candies he doesn’t have , same for all the kids

In the database there is is a field that tracks which kid (partner) submitted the candy (email)

(1) Report A  :     By Candy Type  (Candy types and which list of kids that brought the candy type) In production instead of candy types, we will have emails.

Candy Type A   -  kid 1, kid 2, kid 3, kid 4 

Candy  Type B  - kid 2, kid3, kid4, kid5 

  (2)   Report  B :    By Missing Candy   (which candy type a kid did not bring)

Kid 5 did not bring KitKat,  Snickers,  Hersheys 

Kid 4 did not bring KitKat 

For Report 1   Query needs to track partner file ID Column 

For Report 2   Query needs to generate a list  that does not have the partner file ID column , to identify which candy the other kids did not bring in the jar,   we have to identify which candy type others has brought

Sample Reports 

Report  1  as to which candy a kid brought 

Kid One ;    Candy A  :   Candy 5  :  Candy  6   : Candy 9  

Kid Two  :   Candy  2   :  Candy 6  :  Candy 8    :  Candy 10

Kid Three :  Candy   11,  Candy 20 : Candy 88  : Candy 99

Report  2 as to which candy was not brought by a specific kid 

Kid One :    Did not bring this type of candy 

Kid two ;   Did not bring this type of candy 

Kid Three : Did not bring this type of candy

Production data base is on Google Big Query. I have attached the schema

We are setting up a marketing database involving many partners. If you can do this, you can part of the project and continue to support this project.

Habilidades: SQL, Ciência de Dados

Veja mais: write 200 250 word report companys website, vbnet generate database report, generate csv report using php, sql report examples, how to create a report in sql, sql query for sales report, desktop central query reports, query report writer, sql create report from query, query writing in sql, conduct an analysis of the data set returned by your query, write beta test project report, generate jasper report j2se, write query display current data label column date, generate excel report visual basic, write query display employees hired year, php generate excel report php, asp net write query using crystal report asp, sql query generate report, i need help to write a report to my parents

Acerca do Empregador:
( 52 comentários ) raleigh, United States

ID do Projeto: #27459868

Concedido a:

rkundlik

Greeting!!! I reviewed your requirement, I am Oracle Certified Data Scientist,Analyst Professional having over 5+ years experience in Database development covering multiple technologies like oracle, mysql,sql plsql. I Mais

$30 USD em 1 dia
(0 Comentários)
0.0

13 freelancers are bidding on average $75 for this job

errandssolution

Hi, I will create your ERD Diagrams and ERD database . I am a computer science expert with advanced skills in database management and DBMS.

$140 USD in 7 dias
(0 Comentários)
0.0
kalpesh1702

Hello recruiter, I just read your job description properly and understand what you want. If you want i can start your work right now. I am highly interested to work for you. I have finished many projects like this. Mais

$50 USD em 1 dia
(0 Comentários)
0.0
hireonweb

Back to Work Again Hi, I am Jyoti a Professional in Academic Support and Gaurantees you Grade A. My team and me can offer academic help in Engineering, Computer Science, Humanities like Sociology, Psychology, Physics, Mais

$140 USD in 7 dias
(0 Comentários)
0.2
mehdiahangar1

Hello Regarding my experience in software and web developing, I think this project as making SQL queries is within my ability. I'm also OK with your budget. Please contact me if you're interested in hiring me. Best Mais

$50 USD in 2 dias
(0 Comentários)
0.0
denis333

Hello, I have quite extensive experience with SQL databases, and can help you to solve your issue quick enought for fun :)

$50 USD in 2 dias
(0 Comentários)
0.0
uzair5205oficial

I am very much interested in your job. You have been looking for a database developer who is able to deliver you the best. I consider myself as the right choice for you because I have the right skills and potentiality Mais

$50 USD em 1 dia
(0 Comentários)
0.0
pavelkalganov00

Hello! I can do your job and am ready to start now. If you want me, please ping me so that I can start. Thanks. Send regards.

$50 USD em 1 dia
(0 Comentários)
0.0
xheikhamza

Hi Hope you are fine Here is a Sql Guru, having in experience in Data Science in too ,I also completed Data Analyst Nanodegree Udacity Course which help a lot me to deliver this project successfully (will share certi Mais

$50 USD in 2 dias
(0 Comentários)
0.0
vw7585806vw

HI I go through the description If you share the additional information it will help us to develop. Hands on developing windows based application,Web application with backend [login to view URL] on experience in developing f Mais

$200 USD in 7 dias
(0 Comentários)
0.0
manishsamariya

Hi I have 8 years of experience and database development I am already build that queries I can provide you immediate basis please ping me.

$45 USD em 1 dia
(0 Comentários)
0.0
akshrivastav19

Hello, I am working on Data science Projects where i use SQL queries for pre processing of Data. I have extensive knowledge in building Complex SQL Queries. Thanks

$90 USD in 3 dias
(0 Comentários)
0.0
PriyaSalavi

hello, I would like to work on this project. I ll come up with best Predective model. Please reply back for further discussion. Thank you..!

$30 USD in 5 dias
(0 Comentários)
0.0