SQL - Determining Markup %
Linux, Apache, MySQL, PHP
1
Posts
1
Posters
2
Views
1
Watching
-
I am having trouble figuring out how to write the following problem... "Many organizations use percentage of markup (e.g., profit margin) when analyzing financial data. To determine the percentage of markup for a particular item, simply subtract the cost for the item from the retail price to obtain the dollar amount of profit, and then divide the profit by the cost of the item. The resulting solution is then multiplied by 100 to determine the percent of markup. Using a SELECT statement, display the title of each book and its percent of markup. For the column displaying the percent of markup, use “Markup %” as the column heading."