Aliasing a field
You recently fixed a query to use the correct fields. Now, you need to clean up your code for the report going to the PoweredHomes management team. You'll do this by adding a descriptive alias.
Update the query to include a precise alias for the results.
This exercise is part of the course
Introduction to SQL with AI
Exercise instructions
- Add an alias to label the result of the subtraction as "profit".
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT product_name, unit_price - unit_cost
FROM products;