Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Tim Tyslyuk
12,106 PointsWhy is my calculation wrong?
It seems like the query is right, yet I am off on the calculation, I think this quiz is broken...
Tim Tyslyuk
12,106 PointsThis is my query:
SELECT name, ROUND(price / 1.4, 2) AS "price_gdp" FROM products;
It tells me my calculation is off.
Christopher Shaw
Python Web Development Techdegree Graduate 58,248 PointsPlease put a link to the challenge, else we will be guessing what is being asked for.
4 Answers
Steven Parker
231,248 PointsIt looks like you just have a typo.
The challenge asked for the column to be aliased as "price_gbp" (with a "b"), but you wrote "price_gdp" (with a "d").
Joe Peel
14,384 PointsThanks Steven, saved me some major headache there, damn typos....
Tim Tyslyuk
12,106 PointsI included the question in the comment.
Steven Parker
231,248 PointsAn actual link to the challenge would allow for confirmation of the correctness of the answer.
Christopher Shaw
Python Web Development Techdegree Graduate 58,248 PointsThanks Steven Parker . Tim Tyslyuk , please always try to ask the question from the link provided in the challenge / video, as this automatically links to the relevant content. In the case of a challenge, someone helping can post your code in the challenge screen to see the result and quickly make an adjustment to check they are giving correct advice. The clue to why it is failing is often in the error message provided.
Tim Tyslyuk
12,106 Pointshttps://teamtreehouse.com/library/reporting-with-sql/aggregate-and-numeric-functions/performing-math
Here is the link, sorry, noob on the forum.
Tim Tyslyuk
12,106 PointsSteven thanks, it was a typo that was not passing my query, I spent like 30 minutes trying different ways of converting currency.
Tim Tyslyuk
12,106 PointsTim Tyslyuk
12,106 PointsThis is the question:
In an ecommerce database we have a products table with the columns id, name, category, description, price and stock_count. The price is in USD. Write a query that returns the product name and price in Pounds Sterling (GBP). The current exchange rate is 1.4 USD to every 1 GBP. Alias the calculated price to price_gbp. Round to two decimal places.