How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask ehabtutor Your Own Question

ehabtutor
ehabtutor, MBA
Category: Homework
Satisfied Customers: 1327
Experience:  Software Engineer,business minor,Attending my MBA,Software company owner with 5+ y exp in management
13535664
Type Your Homework Question Here...
ehabtutor is online now
A new question is answered every 9 seconds

Microsoft Server SQL database queries.

Customer Question

Microsoft Server SQL database queries. I need someone to help me create 20 queries for my database within 8 hours. I will be testing the queries in MS server management studio. They are quite easy, but I do not have the time to go through the educational materials to complete them this evening. The queries are being written for 3 tables and their inserts. Tables include tblStores, tblJobTitle, tblEmployee. The tables in question do not have many columns, this is a very small database. Code will be provided after acceptance. Queries needed include:


 


1) Write one SQL query that Selects all the columns in all three tables and JOINs the three tables in the database you created and uses BETWEEN to filter record selection. Use Date of Birth to filter data.


 


2) Write one SQL query that Selects all the columns in all three tables and JOINs the three tables in the database you created and uses BETWEEN to filter record selection. Use No. of Exemptions to filter data.


 


3) Write one SQL query that Selects all the columns in all three tables and JOINs the three tables in the database you created and uses LIKE to restrict record selection (a wild card is required to receive full credit). Use Job ID to filter data.


 


4) Write one SQL query that Selects all the columns in all three tables and JOINs the three tables in the database you created and uses LIKE to filter record selection (a wild card is require to receive full credit). Use City to filter data.


 


5) Write one SQL query that Selects all the columns in all three tables and JOINs the three tables in the database you created and uses an expression (>, =, <=) to restrict record selection. Use Age to filter data. Add an ORDER BY clause and order the results by the Last Name.


 


6) Write one SQL query that uses the UNION JOIN of the two of the tables to produce a third table. (Note: Output should have at least 2 columns from each table to receive full credit)


 


7) Write one SQL query to display employees’ last names and the Job Title and GROUP Job Title


 


8) Write one SQL query to display employees’ last names and their ages and GROUP BY No. of Exemptions.


 


9) Write one SQL query to display employees’ last names and their ages and GROUP BY ages in their Job Title.


 


10) Write one SQL query to display employees’ last names and their job classification and GROUP BY age in Job classification, grouped into Gender.


 


11) Write one SQL Query to JOIN all three tables and select all the data from the tables.


 


12) Write one SQL Query to Increase all employees’ salaries with the selected Job Title by 3.75%. (You select the EEO-Classification of your choice.)


 


13) Assignment Request: Write one SQL Query to Increase all employees’ salaries by 10.57%.


 


14) Write one SQL Query to Calculate the average No. of Exemptions for all employees. (Output shows Alias)


 


15) Write one SQL Query to Calculate the average Age for all employees. (Output shows Alias)


 


16) Write one SQL Query to Calculate the maximum salaries for employees by Job Classification. (Output shows Alias)


 


17) Write one SQL Query to Calculate the maximum salary for all employees. (Output shows Alias)


 


18) Write one SQL Query to Calculate the minimum salaries for Employees by Job Title. (Output shows Alias)


 


19) Write one SQL Query to Calculate the minimum salary for all employees. (Output shows Alias)


 


20) Write one SQL Query to Count all employees by Age and Gender. (Output shows Alias)

Submitted: 1 year ago.
Category: Homework
Expert:  ehabtutor replied 1 year ago.
Hi

It would be my pleasure to assist you on this.

however the price you allocated for the question is too low for the amount of work needed.

So are you willing to increase the question value or maybe add a bonus of 30$ after you get all your 20 queries done and you are satisfied with the answer.

I will also need the database script in order to be able to test all those queries and send you 100% working queries.

Let me know if you agree on this. and to send me the script file go to www.wikisend.com and upload the script file there. you will then be given a download link, copy it and paste it here.

regards,
ehab tutor
Expert:  Susan Athena replied 1 year ago.
Hi. If an answer would still be helpful to you, please provide the database creation script.

Thank you!
Customer: replied 1 year ago.

Hello Susan,

 

I no longer need assistance with 1-5, these are complete. The rest however still stand. Please respond asap. I will monitor my email for your reply for the next 24 hours. I was unable to post the tables and inserts here, I keep getting a server error from Justanswer instead. I will post a link to download the txt document momentarily. I'm not sure if you even need the inserts to write the queries really unless you wanted to test them, but I included them.

Customer: replied 1 year ago.

http://www.mediafire.com/?d94032xovmzomz8

Expert:  ehabtutor replied 1 year ago.
Hi,

My Name isXXXXX responded to you 2 days ago prior to Susan.
It would be my pleasure to assist you on this, if you don't mind.

So Basically you need questions from 6 to 20, right?

When do you need these done? Is tonight suitable?

regards,
ehab tutor
Customer: replied 1 year ago.

Hello Ehab,


 


I did see this, but the price was a bit high.

Expert:  ehabtutor replied 1 year ago.
Ok i will do it for the listed price.

I will leave it to you if you want to add a bonus or not.

And you already finished 5 out of them.

I would be pleasured to help you on this and you can always seek my help on any database or programming related questions.

regards,
ehab tutor
Customer: replied 1 year ago.

Ok, that works for me. Thank you for the price drop. Smile

Expert:  ehabtutor replied 1 year ago.
Ok I will start working on them and send you the answers tonight as promised. Maybe Earlier.

You will be notified by email once i post here.

Have a nice day

Ehab Tutor
Customer: replied 1 year ago.

Thank you very much!

Expert:  ehabtutor replied 1 year ago.
You're welcome

Ehab Tutor
Customer: replied 1 year ago.

Hello,


 


I just wanted to let you know I am going to sleep now. I will check back in a couple hours though.

Expert:  ehabtutor replied 1 year ago.
ok

have nice dreams.

I will post them as soon as i am done.

best regards,
ehab tutor
Expert:  ehabtutor replied 1 year ago.
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
If you've already paid for this answer, simply Login.
ehabtutor, MBA
Category: Homework
Satisfied Customers: 1327
Experience: Software Engineer,business minor,Attending my MBA,Software company owner with 5+ y exp in management
ehabtutor and 5 other Homework Specialists are ready to help you
Customer: replied 1 year ago.


Hi there,


 


I am at work at the moment, but when I get home this evening and test them I will be sure to leave you feedback and a bonus.

Expert:  ehabtutor replied 1 year ago.
Sure.

I will await your reply in case you need any further assistance.

If you need my help at any time. Just post a question starting "To Ehab Tutor" and i will be at your help

regards,
ehab tutor
Customer: replied 1 year ago.


Thanks a lot! You will be hearing from me this evening. Laughing

Expert:  ehabtutor replied 1 year ago.
ok
Expert:  ehabtutor replied 1 year ago.
Where you able to check the answers?

I didn't hear back from you

regards,
ehab tutor
Customer: replied 1 year ago.

Hi, sorry I got sidetracked after I work. I am taking a look now I will pay shortly!

Expert:  ehabtutor replied 1 year ago.
Sure thing.

Let me know if you need any further help.

regards,
ehab tutor
Customer: replied 1 year ago.

Did it give you the 45 + the 15$ bonus? I didn't think I had that much added to my account, and it didn't prompt me to add additional funds.

Customer: replied 1 year ago.

It looks like it did in my transaction history, just checking though.

Expert:  ehabtutor replied 1 year ago.
yeah i think the question initially had 43$ allocated and you added 15$ as a bonus.

Thank you very much.

I will await your next question. Just remember to begin it with "**** To Ehab Tutor Only ****" and i will be at your help

regards,
ehab tutor
Customer: replied 1 year ago.

Ok, will do! Thank you very much!!!!

Customer: replied 1 year ago.

By the way, I will most likely be posting something for you tomorrow that will be due on Monday. Just a heads up!

Attachments are only available to registered users.

Register Here

Attachments are only available to registered users.

Register Here

Attachments are only available to registered users.

Register Here
View Full Image

Attachments are only available to registered users.

Register Here

Expert:  ehabtutor replied 1 year ago.
Sure.

Ready to go.

So Remember to add "*** To Ehab Tutor Only ***" at the beginning of the question to address the question to me.


regards,
ehab tutor

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4522
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4522
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3458
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3124
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2385
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1988
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1876
    Bachelors Degree and CPA with Accounting work experience
  • http://ww2.justanswer.com/uploads/avremote/photoa.jpg Seanna's Avatar

    Seanna

    Tutor

    Satisfied Customers:

    1781
    3,000+ satisfied customers, all topics, A+ work
 
 
 

Related Homework Questions

Chat Now With A Tutor
ehabtutor
ehabtutor
C.E.O
72 Satisfied Customers
Software Engineer,business minor,Attending my MBA,Software company owner with 5+ y exp in management