ASSIGNMENT 1

1. Create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, state, and zip code for each customer. Each customers name should be listed in order of last name followed by first name, separated by a comma, and have the column heading NAME. The city and state should be listed as one column of output, with the values separated by a comma and the column heading LOCATION.

2. To determine the percentage of profit for a particular item, subtract the items cost from the retail price to calculate the dollar amount of profit, and then divide the profit by the items cost. The solution is the multiplied by 100 to determine the profit percentage for each book. Use the SELECT statement to display the books title and percentage of profit. For the column displaying the percentage markup, use PROFIT % as the column heading.

When answering I just need the answers not the steps. thank you.