Hi,

How to answer this question. (The answer in the blank was wrong).

Thx

SQL COMPUTING NEW VALUES Drag mouse over text to highlight it. Mouse over icons learn what they do Sometimes your work requires data that does not yet exist so it must be calculated. SQL permits this and the next example demonstrates how to calculate new values The table "order details" has columns including the UnitPrice of an item and the Quantity of that item purchased. If you wanted to know the extended cost (UnitPrice times Quantity) of each item sold then calculate it this way select unitprice, quantity, unitprice * quantity from 'order details Since the table name, order details has a space, it must be surrounded by' when used in a query. REMINDER UNITPRICE QUANTITY UNITPRICE" QUANTITY 168 34.8 18. 6 5 174 9 167.4 401696 42. 4 7.7 77 Notice the heading for the computed column "UNITPRICE * QUANTITY". The next page describes how to make it more descriptive CHECKPOINT Click and try CHECKPOINT Project the salary then bonus amount for each employee Bonus is calculated as salary times. 1 Do not name the calculated column. Use the employee table and the salary column. There is no bonus column so do not use it select salary, salary +.1, salary * salary *.1 fron enployee CHECK MY ANSWER Did you use the correct table name: employee? Did you use the correct columns: salary? Did you perform the correct calculation? Remember project two columns: salary and the bonus amount. Do not rename the calculated column I CHECKPOINT button does not respond click yellow circle in upper right of this page