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 LogicPro Your Own Question
LogicPro
LogicPro, Engineer
Category: Homework
Satisfied Customers: 12726
Experience:  Expert in Java C++ C C# VB Javascript Design SQL HTML
29751445
Type Your Homework Question Here...
LogicPro is online now
A new question is answered every 9 seconds

1 Show the employee ID number and name for only the first three

This answer was rated:

1 Show the employee ID number and name for only the first three employees (the ones with the three lowest ID numbers).
Hint: use TOP while sorting by ID number. Format all columns using CAST, CONVERT, and/or STRING, and rename the
columns using AS.'

2 For each row in the REPAIR_LINE_ITEM table, show the repair number, line number, and values of ExtendedPrice
and "Labor Charge" added together (rename this value to TotalCharge). Sort results in descending order by TotalCharge.

3 Show the name, street address, and city/state/ZIP code for all customers who live in Oregon. Combine
city, state, and ZIP code into a single line in this format:

"Portland, OR 97201"

...and rename this column City/State/ZIP (exactly this name! there is a way to do it).

4 For all STOVE_REPAIR records, show the repair number, stove number, repair description, and repair date.
Order the data chronologically by repair date (most recent first), and display the date in this
format: MM/DD/YYYY. Format the output to be readable (i.e. to fit neatly into a page)

5 For all INVOICE rows which have a TotalPrice value between $100 and $200 (inclusive), show the invoice number,
total price, and employee number. Order the output by invoice number. Format all three columns using STR;
display the cost as money (i.e. use two decimal places for cents, and put a dollar sign before it; e.g. $12.54).'
Hi,
Welcome here.
My name is XXXXX XXXXX I will help you.

Can you provide me table structures?
If you have any file(s), Zip all files; upload the zipped file to http://wikisend.com or http://ge.tt and post download link here.
Customer: replied 3 years ago.


hi

Hello,
Can you provide me table structures?
If you have any file(s), Zip all files; upload the zipped file to http://wikisend.com or http://ge.tt and post download link here.
Customer: replied 3 years ago.


I am trying to collect the information can u please give a minute?

ok
Customer: replied 3 years ago.


DID YOU GET?

Please paste download link here.
no, once you upload the file to www.wikisend.com, you will get a 6 digit number, paste that number here.
Customer: replied 3 years ago.


CAN U GIVE ME TO DOWNLOD AGAIN

Open www.wikisend.com

Browse for your file.

Click on upload button.

You will see a file ID or download link.

Paste download link here.

Customer: replied 3 years ago.
Please provide me database also on which these queries needs to be executed?
Customer: replied 3 years ago.


I only have that one

ok, what is the deadline?
Customer: replied 3 years ago.

I just need for now

also let me know which database you are using?
Customer: replied 3 years ago.


what do you mean?


 

oracle, my sql, sql server, MS Acess?
Customer: replied 3 years ago.

sql

please check back in 1-2 hours for answer.
Customer: replied 3 years ago.


okay

ok..
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
LogicPro and other Homework Specialists are ready to help you
Hi HANA,
Just following up with you to see how everything is going and if you have more questions for me.
You can ask me again using "For LogicPro only" at the start of your questions like you do to get instant answers.
It will ensure that question is for me.
Please bookmark my profile page:
http://www.justanswer.com/homework/expert-logicpro/
so you can come back and ask me a question anytime.
If you need any additional information on this answer, please don't hesitate to ask by clicking on 'Reply to Expert', and I will reply as soon as possible.
I hope you found the information in my answer helpful, and if so, please let me know, here. Thank you!
Thanks very much for using Just Answer!
Best wishes
LogicPro

Related Homework Questions