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.
Este ejercicio forma parte del curso
Introduction to SQL with AI
Instrucciones del ejercicio
- Correct the query so that it subtracts the
unit_costfrom price.
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
SELECT product_name, unit_price - cost
FROM products;