Correct calculations
You prompted the AI assistant to help with a calculation, but it used a field cost that doesn't exist in the PoweredHomes database. You need to replace it with the correct field to complete the operation of subtracting cost from price.
Use what you've learned about data types and prompting to fix the query.
Keep an eye on the output, something odd happens to the field name. We'll learn how to fix it next.
Cet exercice fait partie du cours
Introduction to SQL with AI
Instructions
- Correct the query so that it subtracts the
unit_costfrom price.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
SELECT product_name, unit_price - cost
FROM products;