Find Jobs
Hire Freelancers

need guy who can do queries in MYSQL join,nested loops

₹100-400 INR / hour

Zaprt
Objavljeno pred približno 9 leti

₹100-400 INR / hour

Create a VIEW dbo.vw_Commissions to display the commissions earned last year by all sales employees. Round the result set to two decimal places and do not include any salesperson who did not earn a commission. Include the salesperson name, the commission earned, and the job title. Concatenate the salesperson first and last names. Using nested queries (correlated query) to display the total Last Year Sales converted in Mexican pesos that occurred in July 1, 2005. Only nested/correlated queries will be accepted. Round the result set to two decimal places [login to view URL] HINTS: • Observe the ToCurrency column and the value corresponding to the Mexican Pesos • Use a wildcard in the Name of the currency • Make sure you use the correct convention for the date field • Use the proper aggregate function Display the Salesperson who earned the highest commission last year. Include the sales person name (concatenated First and Last Name), the Job Title, and the total commissions earned. Name the query [login to view URL] 4. List all orders placed between August 10 and August 20 in 2005. List the order date, orders and the territory. Name the query [login to view URL]
ID projekta: 7297350

Več o projektu

11 ponudb
Projekt na daljavo
Aktivno pred 9 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
11 freelancerjev je oddalo ponudbo s povprečno vrednostjo ₹259 INR/uro za to delo
Avatar uporabnika
Hi, I have gone through your project details and PDF file attached and would like to take an opportunity to work on it. As I can see from the details work need to be done in MSSQL database not MYSQL database. I have worked on several projects of writing queries and functions on MSSQL and can help you with required solution for 4 queries required in the project. Waiting for your response for more discussion in detail and plan out activity. Thanks.
₹277 INR v 3 dneh
4,9 (104 ocen)
5,9
5,9
Avatar uporabnika
I will be able to do this work for you. The number of hours will be greater than one, the cost of the total project will be at least 18/22 hours. Please write to me if you need assistance with your project. Thanks Deb
₹300 INR v 1 dnevu
4,5 (3 ocen)
3,4
3,4
Avatar uporabnika
Hi. I am professional database developer with experience in all major DBMS-es including oracle. My offer is fixed for that project, I will complete queries in 1 day for 1350 inr. If you like my offer, feel free to contact me. Thanks
₹277 INR v 5 dneh
5,0 (8 ocen)
3,3
3,3
Avatar uporabnika
HI i have more than than 7 years of expereince in query development and willing to help you to do this in a quick and easy manner.
₹277 INR v 3 dneh
4,9 (9 ocen)
3,1
3,1
Avatar uporabnika
Hi, I can do this. I'm currently working in asp.net with mssql. I understand that you need some queries that return different results as stated in your assignment. Appreciate if you would assign the work for me. regards, JY
₹333 INR v 1 dnevu
5,0 (1 ocena)
1,6
1,6
Avatar uporabnika
im expert in sql, actually i work in pemex in mexico, realize projects in reporting services use sql procedures.
₹277 INR v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
i have recently certified sql oracle course... i want to taste myself tooo.. So please give one chance..... also i need a sample data for work
₹211 INR v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I have worked on SQL related queries and DB admin jobs for past three years. I have a hands on experience in Oracle 9 , 10 , 11 and 12 versions. I have experience in DB tuning, Oracle import and export as well. I have worked on numerous client projects while working at JDA Software as a part of the Product Development team.
₹277 INR v 12 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
A proposal has not yet been provided
₹233 INR v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hi, I am expert in database development work with 6 years of experience in this field. I can complete this as soon as you want. Looking forward to work on this. Thanks Vinod Kumar
₹277 INR v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Can deliver the require query within an hour. Please provide me with the table structure that's it. I can provide you one of the test query free of cost without any charge.
₹111 INR v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava INDIA
Bangalore, India
4,8
231
Član(ica) od jan. 29, 2011

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.