Find Jobs
Hire Freelancers

modify sql query ASAPPP

$30-250 USD

Closed
Posted about 3 years ago

$30-250 USD

Paid on delivery
i have thos db schema and i need a query to give a list of employeees who have the same org unit as their manager and are currently not involved in any project.
Project ID: 30043995

About the project

16 proposals
Remote project
Active 3 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
16 freelancers are bidding on average $91 USD for this job
User Avatar
Hello, hope you doing great. I can do it. I am ready to start work as soon as you confirm. Relevant Skills and Experience I have more than 3 years of professional experience in PHP, CSS, HTML, JS,Vue, Jquery, Bootstrap,Angular, Ajax,Laravel, python ,Wordpress, MERN.
$30 USD in 1 day
4.9 (25 reviews)
5.3
5.3
User Avatar
Hello there, after seeing your schema, to get the data from employee who has the same organization and not involve in any project we need to join 3 tables: employees, organization units and the project. Pls share me your schema and the data and we will do this. I think it will take at most 2 hours. Waiting for your response if interested. Thank you!!!
$50 USD in 1 day
5.0 (29 reviews)
5.2
5.2
User Avatar
Hello. I have gone through the schema shared by you. Assuming that the Managers ID is present in the Employee Table, we will need to work around the "employee" and the "employee_projects" tables. I can write this query for you and if you have even more complex queries, i can do them for us, as i not only have a lot of experience in SQL, but i have developed a number of HR Systems, so i have the technical and business knowledge as well. As an SQL Developer, i have developed optimized database objects (including Views, Stored Procedures, functions, etc) for numerous systems. I have expertise optimizing databases, queries and stored procedures, with hands on experience on huge transactional systems. I also have experience analyzing, cleaning and importing data. I have loads of experience in extracting meaning ful information from huge chunks of raw data, based on required criteria. I can start right away. I am looking for a long-term relationship based on Quality of Work, Professionalism and Honesty. Kindly have a look at my resume for better understanding of my skills and experience: http://technologyjunction.com.pk/downloads/Screenshots/HaroonMushtaq-Resume-PM&SolutionArchitect).pdf Looking forward to hear from you. Have a good day!
$87 USD in 7 days
4.8 (23 reviews)
5.1
5.1
User Avatar
Hello I am ready to start now and i can modify sql query.I have checked pdf and am pretty much sure i can help you out. Thanks Ridhima
$90 USD in 1 day
4.4 (7 reviews)
4.4
4.4
User Avatar
Hi I have 15 years of experience in SQL server Development, MYSQL, Postgress. I will be able to help you with the project. Please ping me offline to discuss further
$250 USD in 4 days
5.0 (8 reviews)
2.9
2.9
User Avatar
Hello, I have 4 years of experience in IT field with CMMI Level V company. I would like to do work for you and complete your given task with in a time.
$56 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I am read your projects details and also see this pdf. I am web developer and have more experience about web design and development and also have more experience about Mysql. Please tell me details about your work.
$150 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi.. I have five years experience in SQL. I can do it for you and give you most effectively answer.
$140 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Having 7 years of expertise into writing SQL queries. Can write complex requirements in the from of SQL queries with performance measures. Please ping me in the chat for further discussion.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an experienced Data Scientist. Working on SQL Queries on Daily Basis. I am kind of understand about the problem given. Feel free to contact me, and looking forward to collaborate !
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am senior Database , SQL And BI developer with more than 6 years of experience. Let us to start ,i can do it.
$140 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am very much interested working with this, I have more than 10 years experience with SQL programming.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have strong background in all aspects of MS Sql Server environment. But i'm new at freelancer and i want to make a good start by your project.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have 10 + years of experience in writing sql queries. Please ping me asp. Hoping to hear from you soon. Thanks
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ALBANIA
Tirana, Albania
0.0
0
Member since Aug 21, 2020

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.