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 ATLProg Your Own Question

ATLProg
ATLProg, Software Engineer
Category: Homework
Satisfied Customers: 8647
Experience:  Expert in Java C++ C C# VB Javascript Design SQL HTML
44910485
Type Your Homework Question Here...
ATLProg is online now
A new question is answered every 9 seconds

Hi, I need help with an assignment due by 11:59 PM EST on Sunday

Resolved Question:

Hi, I need help with an assignment due by 11:59 PM EST on Sunday Nov, 10 2013. I had some issues with an out patient surgery, but my professor is not being very helpful in giving me time to learn the material or in giving me an extension.
Anyway, the layout of the tables is not important (which is making it even harder for me because we do not actually have the tables so I can't check my work) he just wants to see that the code is written properly in terms of syntax and logic. I know it's a lot and a short time, but I am desperate for help and I am not getting it from my professor. I have contacted the Dean, but apparently the professor is not "required" to offer any additional help other than the basic assignments and lectures, but since this is an online class, all of that is canned anyway. Hopefully this professor is not hired again, I know that many others in the class are having the same issues.
There are 18 questions:

1.Write a query to display your name, and the current date on a single line of output

2. Display using the employees table the employee id, last name, hire date, and salary, of every employee who was hired after 7 June 1994.

3. Write a query to modify the previous query and display the hire dates that are between January 1, 1998 and December 31, 2000.

4. Write a query using the jobs table to determine what the max salaries would be if the marketing managers were given a 10% raise. Label the column New MKT MGR. Display three columns from the jobs table including the max_salary column.

5. Using the job_history table display the employee numbers, department id, and start date, which is the first FRIDAY six months from the start date. Format the dates to appear in the format similar to “Friday the Tenth of January, 1997”.

6. For each Employee in the employees table display the employee_id, job_id, department_id, salary and calculate the number of months between today’s date and the hire_date. Label the column MONTHS BETWEEN. Round the number of months up to the closest whole number.

7. Write a query using the jobs table that produces the following output concatenated: , has a minimum salary of, , but a maximum salary that is more than the min_salary. Provide a column alias for each column.

8. Write a query using the locations table to display the STREET_ADDRESS in uppercase, the CITY in lowercase and the length of the STATE_PROVINCE. Order the results by the POSTAL_CODE.

9. Write a query using the employees table to display the employee id, last name and hire date for four specific employees without using the ‘or’ operator.

10. Write a query using the jobs table to display the job id, and job title for three specific jobs whose job description starts with an M.

11. Write a query using the jobs table to display the job id, and job title for job descriptions that have the string ‘present’ or ‘hip’ in the job title.

12. Write a query using the employees table that displays the department id, employee id, manager id and salary where the commission pct is not null.

13. Create a unique listing using the jobs table of all the jobs that have a minimum salary of 4000. Include the all of the columns in the output.

14. Create a query that will display the employee id, manager id and hire date. If the employee does not receive a commission put “No Commission is Paid”. Create an alias for the column.

15. Write a query using the employees table to display the employee id, hire date, and salary for all employees with a hire date of 24 March 1998.

16. Write query using the locations table that displays the street address and city of all locations based on the value of the column country id as follows:

IT Italy

JP Japan

CN Canada

UK United Kingdom

NL Netherlands

17. Write query using the locations table that displays the street address and city of all locations based on the value of the column country id as follows:

IT Italy

JP Japan

CN Canada

UK United Kingdom

else display Another Place

18. Display the highest and lowest hire date of all employees in the employees table. Label the columns Largest and Smallest.
Submitted: 9 months ago.
Category: Homework
Expert:  ATLProg replied 9 months ago.
Can you please upload erd or database on www.wikisend.com and post file id.Also upload anything else related too this assignment you may have
Customer: replied 9 months ago.

This is quite literally all that I have. We have no additional information what so ever. The professor has told us, after we asked repeatedly how we were supposed to complete this, that it is all theoretical. None of the tables exist, we are just supposed to use place holder type names for columns. For example, if it asks for the employee id, we use employee_id.


 


I am doing this in sql Plus by the way, I don't know if that really matters though since nothing really exists anywhere.

Expert:  ATLProg replied 9 months ago.
ok
Expert:  ATLProg replied 9 months ago.
Let me take an attempt at this requirements are as you said aren't clear at all. Looking at number of questions and effort please confirm if price of 90 sound ok
Customer: replied 9 months ago.

I completely agree about the instructions. That is the main reason I was looking for some help with this; it is far to unclear in just about every way. Unfortunately I can't afford a 90 price. As it is I am stretching myself thin with the 55. I can understand asking for more though. No worries at all if the payment is too low. I will just tell my professor I couldn't do it.

Expert:  ATLProg replied 9 months ago.
let me see what i can do i will keep you posted
Expert:  ATLProg replied 9 months ago.
Please let me know if you still need this answer
Customer: replied 9 months ago.


I do, but like I said, $55 is as high as I can go. Any amount of help would be appreciated as this is for my midterm and I am really struggling with this class.

Expert:  ATLProg replied 9 months 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.
ATLProg, Software Engineer
Category: Homework
Satisfied Customers: 8647
Experience: Expert in Java C++ C C# VB Javascript Design SQL HTML
ATLProg and 6 other Homework Specialists are ready to help you
Customer: replied 9 months ago.


Thank you for this work. After seeing your solutions, I can actually dort of reverse analyze some of the questions and it is helping me to learn the process better.

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:

    4520
    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:

    4520
    More than 5000 online tutoring sessions.
  • 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:

    3121
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3035
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/lanis/2009-4-1_233717_phput9xef_c1pm.jpg Lani S.'s Avatar

    Lani S.

    Tutor

    Satisfied Customers:

    2457
    Registered Nurse, Internet Researcher, Private Tutor
  • 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:

    2341
    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:

    1975
    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:

    1873
    Bachelors Degree and CPA with Accounting work experience