I am typing in this query:
i13 display name, price and sum quantity for all fruit, even ones with quantity null
select inventory.fruitID
concat( "$", quantity * price ) as "value"
from fruit right join inventory
on fruit.fruitID = inventory.fruitID;
I am getting this message:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '( "$", quantity * price ) as "value" from fruit right join inventory on fruit.fr' at line 3
What am I doing wrong?