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 Steve Your Own Question
Steve
Steve, Consultant
Category: Programming
Satisfied Customers: 423
Experience:  Steve is a consultant in the areas of computer software and programming, information management and networking.
47680681
Type Your Programming Question Here...
Steve is online now

Can someone help with the SQL code to 1. Change the header

This answer was rated:

HI, Can someone help with the SQL code to
1. Change the header as CategoryID to Per Category
2. Round the average unit price to two decimal places
I will attach a screen shot of the query and current attempt
Customer: replied 5 months ago.
HI I have added as screen shot of the query and my attempt

Hi, this is Steve again.

ROUND(AVG(UnitPrice),2) AS 'Per Category'

Let me know if that works for you.

Customer: replied 5 months ago.
Hi Steve, Great that I have you helping again. I have given you a rating of 5 for my other question :)I have tried your suggestion but it is coming up with an error - please see screen shot
Customer: replied 5 months ago.
Hi Steve I have solved this one. Working on the next query

OK. Sorry, it would be better if I could type it in before I tell you what to put because I don't always get the syntax exactly right off the top of my head.

What was the solution?

Steve and 7 other Programming Specialists are ready to help you
Customer: replied 5 months ago.
Hi Steve, They didn't actually want a rounded average price, as I was really baffled as to why I couldn't round it. I had the title heading wrong and corrected that eventually