write a query to generate the following report -- 2

Completado Publicado hace 3 años Pagado a la entrega
Completado Pagado a la entrega

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.

SQL Ciencia de datos

Nº del proyecto: #27459868

Sobre el proyecto

12 propuestas Proyecto remoto Activo hace 3 años

Adjudicado 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 Más

$30 USD en 1 día
(1 comentario)
1.0

12 freelancers están ofertando un promedio de $77 por este trabajo

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 Más

$50 USD en 2 días
(5 comentarios)
2.6
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 en 1 día
(3 comentarios)
2.8
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 en 7 días
(0 comentarios)
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. Más

$50 USD en 1 día
(0 comentarios)
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, Más

$140 USD en 7 días
(0 comentarios)
0.3
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 Más

$50 USD en 2 días
(0 comentarios)
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 en 2 días
(0 comentarios)
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 Más

$50 USD en 1 día
(0 comentarios)
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 en 3 días
(0 comentarios)
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 en 5 días
(0 comentarios)
0.0