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.
Diese Übung ist Teil des Kurses
Introduction to SQL with AI
Anleitung zur Übung
- Add an alias to label the result of the subtraction as "profit".
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT product_name, unit_price - unit_cost
FROM products;