Find Jobs
Hire Freelancers

Correct MySQL Query Errors

$10-30 USD

Closed
Posted almost 5 years ago

$10-30 USD

Paid on delivery
Hi this is a fiddle of my DDL and query - can someone remedy the issues I have so the query executes? [login to view URL]
Project ID: 20715750

About the project

25 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
25 freelancers are bidding on average $23 USD for this job
User Avatar
Hi, I have over 11 years of database development experience. I can fix the query issues quickly. Please let me know if you are interested to proceed. Regards, Farooq
$25 USD in 7 days
5.0 (24 reviews)
5.9
5.9
User Avatar
VERY EASY FOR ME As you can see in my review, I've done similar with yours https://www.freelancer.com/projects/sql/SQL-SCRIPTS-20154208/?w=f https://www.freelancer.com/projects/sql/SQL-Distinct-query-Delete-Query/?w=f https://www.freelancer.com/projects/mysql/mysql-data-sql-database/?w=f https://www.freelancer.com/projects/php/database-help-18647810/?w=f Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time. I am well experienced and skillful Database(SQL, MSSQL, MYSQL), PHP, Java and C++ programmer. I have +5 years of experience in software developing. I have finished a lot of project like this. I ensure the best quality of your project and to keep your deadline. Please contact me kindly and let us discuss in more detail. Working with me, you will have a good experience and good friend and save more time and money. After complete project, I can support fixing bugs with free. and support update features with low price. Best regards!
$30 USD in 1 day
4.6 (19 reviews)
5.1
5.1
User Avatar
yes i can, just send me a message right away, to get it done............................................................
$30 USD in 1 day
4.9 (12 reviews)
4.9
4.9
User Avatar
Hi i am expertise in sql queries if u are interested ping me we will connect and finish ur requirment
$35 USD in 1 day
4.8 (17 reviews)
4.5
4.5
User Avatar
I am expert in database programming specially working with mysql, oracle and ms sql. I am new here but I provide best quality services to my clients. Please give me a chance to do so.
$10 USD in 1 day
4.6 (30 reviews)
3.8
3.8
User Avatar
Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully and I am very interested in your project. I am sure that I can finish this project of 100% result in short time with the reasonable budget
$19 USD in 1 day
4.8 (7 reviews)
3.7
3.7
User Avatar
I have more then 10 years of experience in SQL Server databse development and Administration.  I have worked with medium to large mission critical databases.  Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I am looking for full time or hourly  remote job.
$35 USD in 1 day
5.0 (6 reviews)
3.3
3.3
User Avatar
Hi, I can help you to make the query successful. I can do it in one day and will deliver it as soon as possible.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, looking at your project description, I think this is the best suited job for me as I have over 8 years of experience in Database Development along with Performance Tuning. I have worked on various Databases like Oracle, SQL server, PostgreSQL etc. I have done OCA certification in Database Development and Oracle 12c: Performance Tuning and Management certification. Expecting a call from you where we can discuss further and I can prove my knowledge for this job to you.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have many years experience with query. With many databases i have experienced. Like sybase, mysql, postgrey, sql You can give me a shot handle ur project.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I had solved your problem of SQL and can tell you the issues, so that your query will execute. I have 10+ years of experience in development of JAVA/J2EE projects. I am interested in your project. Looking forward to hear from you. Thanks & Regards Amit Jain
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am database developer with 5 years of strong experience in IT companies. I have strong analytical and bug fixing skills in database. I can solve these issues ASAP.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Send me a description of what exactly you want to do with this SQL query, and I will be happy to resolve it.
$28 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As I work on back end problems and I have knowledge about SQL and MYSQL I can solve the problem remove errors easily.
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I have an experience of 2 years as MySQL developer.I love challenges and therefore I'm looking forward to solve the errors or providing queries. Relevant Skills and Experience SQL,plsql
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Add a field in DDL which is a primary key so that The query will work correctly. Not required to bid you can do it easily yourself.
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
BCOMP software engineer that is experienced in a variety of Structured database language's from SQL to MYSQL , Oracle and even the non structured query languages like firestore, please let me know when we can get started So I can help you resolve your problem as efficiently and as fast as possible.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
There are some syntax errors in the code. That is the reason why it is failing. Also the version in which we run the code is important. I have expertise in developing complex SQL codes so I can efficiently complete this project on time. Firstly, the version needs to be set to v8.0 while executing the query. Second, the table names are case sensitive. Then there is a syntax error in LEFT JOIN. After resolving the syntax errors, I could find that obtaining the desired result is a bit tricky. But I was able to achieve that without creating a temp table. I have the revised code ready with me and we could discuss more on that if you are willing to accept my bid. Thanks
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Athens, United States
0.0
0
Member since Aug 9, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.