write this simple query for GCP -- 3

Query is for Google (GCP) Big Query.

4 real estate marketing companies have decided to pool their leads. They will data dump their marketing leads list into one single database in Big Query. .

At the end of the month, I need to give each company a list of fresh leads. Fresh leads are defined as leads they were not aware of previously. The leads they did not add into the database

The columns , partner, source and partner file _id can be used to create this query


This is a long term job. you will help me execute AI / machine learning projects on this database

Skills: SQL

See more: bigquery query examples, bigquery pricing, gcp console, bigquery, bigquery create table, unnest bigquery, data studio, bigquery tutorial, write simple text based game code, write simple asp form, simple text based java projects, write mysql query, write simple email backup script, write simple excel program, visual basic sample projects used hospitals, use net write simple browser, simple solar cell panel projects, simple java chat windpw projects, write simple program, write simple programs excel

About the Employer:
( 53 reviews ) raleigh, United States

Project ID: #27518189

4 freelancers are bidding on average $16/hour for this job


Hi there How much data do you have? and do you want a real-time model? Just as a short introduction, we have a team of experienced Machine Learning and Deep Learning Experts who would be glad to help you shape your req More

$10 USD / hour
(0 Reviews)

GCP programmer here. I have worked in google BQ and I can show demo from own GCP account and also if possible the

$32 USD / hour
(0 Reviews)

Hi I am ready to work free of cost as an apprentice. Just to have the learning experience. Having that said I have 10 years of IT experience. Thanks Abhishek Rai

$8 USD / hour
(0 Reviews)

I have 10 years experience in MYSQL, database programming and last 2 years in GCP. Using mysql, I have written proficient queries to process huge amount of data and have worked on various components. Also I have used More

$15 USD / hour
(0 Reviews)