Give me SQL query based on my DBS
£10-20 GBP
Paid on delivery
Hello, I need 10 query to be done for my sql databases. Below are the statements
1. Write an SQL statement to list all employees who are working in the Sales department for which the hire date is between 1995 - 2008
2. Write an SQL statement to show all titles of employees who are getting more than £20000 salary and for which the hire date was after 1985
3. Write an SQL statement to show the full names, salaries and gender for those in the HR department.
4. Write an SQL statement to show that all employees names, department names and their departments’ managers.
5. Write an SQL statement to show a list of employees who were hired between 1980 and 1995 and whose first name starts with A or S
6. Write an SQL statement to change the employee’s title who works in the finance department and whose first name starts with ‘S’.
7. Write an SQL statement to increase the salaries of all employees up to 10 % for those who have been working since 1997 and work in the Marketing department.
8. Write an SQL statement to delete employees’ record in the sales department and whose last name starts with A or S
9. Create a database view to list the full names of all employees, salaries, their departments, and departments manager
10. Create a database view to list all employees, departments and their departments’ managers of those who were hired between 1990 and 2000.
Project ID: #30091592
About the project
Awarded to:
I'm free now, I can start the task right away, I have over 20 years of experience as a software developer, and I have very strong experience in all kinds of Database, store procedure.
14 freelancers are bidding on average £30 for this job
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, Bootst More
Hello. How are you? I've read your job description and it's very interesting to me. As an experienced SQL expert I can surely help you. I am good at building relational database and making complex quries on it. Looking More
Hello, I hope this finds you well. I have just seen your project requiring; SQL MySQL Database Administration Database Programming Microsoft SQL Server I believe that my 8-year experience in this field is what you ne More
Hi, MS SQL experienced developer is here. We have more than 5 years of experience in the field. I have read your initial description of your project. I have some queries regarding to your project. Can we discuss timeli More
I read 10 statements and your database. I think That 's simple, please give me message , you 'll get sql querys. Thank you.
Hi, I'm a full-stack software engineer with strong knowledge in developing websites and web apps, as well as writing SQL queries. Feel free to send me a message so we can discuss it. Best regards, Omer
-previous experience in such topics; -eager to discuss a lot in this chat stream; -degree stats / maths;
hello Daniel, i am full-stack developer ( react and nodejs) Afterwards, i cant create the quries u want within a day . feel free to contact me .
hello sir, I hope it find you well. I will do your project in just 15$ within the due date. For further discussion please send me a message I am available 24/7
I can help you in your sql query i, i had worked to those kind of queries since i was in my first year at university , well SQL querie are my everyday routine
