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]
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.
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
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
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
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.
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
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.