Write an SQL Query to Clean Some Data

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I need and one ore more SQL query to clean some data in the following way:

1. If the BBSctr field is empty insert the most frequently used BBSctr corresponding to the SpnsrSctr of that record by that Spnsr. Note that different Spnsr may have different "most frequent" BBSctr associations.

2. When there is neither a SpnsrSctr or BBSctr search for any BBSctr association of CnsTckr and assign the most frequent there.

You may not use temporary tables but you can create explicit mapping tables. Execution speed is important but not my primary concern at this time.

Sample data is provided attached.

MySQL SQL

Project ID: #11266845

About the project

22 proposals Remote project Active 7 years ago

Awarded to:

davedcb

Hello, Hello, I am interested in your project. I am a software engineer and I have professional experience with MySQL. I suggest to create 2 mapping tables (Table 1 - Spnsr, SpnsrSctr , Most Frequent BBSct) rand More

$85 USD in 1 day
(23 Reviews)
4.1

22 freelancers are bidding on average $147 for this job

toseef3

Dear Sir, Hope you are doing well, I have read your job description, I am willing to work with you. I have already done similar job and win 5 star rating with wonderful review. Key Responsibilities are : More

$249 USD in 7 days
(20 Reviews)
7.8
alyaspk

Dear Employer, I am ready to work on your required task and can assure 100% satisfaction. You can read reviews/details about my past work on my profile http://www.freelancer.com/u/alyaspk.html Looking forward t More

$147 USD in 3 days
(88 Reviews)
7.2
schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had More

$66 USD in 1 day
(61 Reviews)
6.7
nyarOnyari

Hello, I have read your project description about Database Design and I would appreciate if you can open discussion with me and I see how we can work together. Am a graduate in Computer Science and have already desig More

$99 USD in 3 days
(37 Reviews)
5.0
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologie More

$88 USD in 1 day
(22 Reviews)
5.3
hotuanthanh

I have experienced in SQL administration, design and manipulation for more than 6 years. I successfully design and implement the databases for a transportation system, a bus system, and many other systems. I believe I More

$155 USD in 3 days
(2 Reviews)
3.2
osypets

Hello! I am interested in your project and I want to discuss with you the details of it. I have extensive experience in system administration and integration of products of varying complexity. I also represent th More

$150 USD in 3 days
(2 Reviews)
2.9
kishanvkc

Ready to work right now. I have check it...i will do query for clean data. I will take charge $40 for your project. Thanks, Kishan

$45 USD in 2 days
(0 Reviews)
0.0
niral51patel

Dear Sir, Greetings from Niral Patel, I gone through the detailed requirement and found that you are looking for someone who is experienced with SQL to manage your database. I have good experience in building qu More

$85 USD in 1 day
(1 Review)
0.0
cbathina

Hello, I can do this for you in 3-5 days. i work for a corporate and create the queries every day. Let me know if i can do this for you.

$250 USD in 5 days
(0 Reviews)
0.0
albertbekte

I can code that, let's go!

$45 USD in 1 day
(0 Reviews)
0.0
Thoughtimpulse

I have deep experience with respective to DATA MANAGEMENT, DATA TRANSFORMATION, DATA PROCESSING AND DATA STORAGE & Etc with various types of database systems like SQL Server, My Sql, Oracle and many. I can promise y More

$155 USD in 3 days
(0 Reviews)
0.0
Amol29

A proposal has not yet been provided

$222 USD in 8 days
(0 Reviews)
0.0