Naming document: firstname_db_assgn1.doc 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 customer's name should be listed in order of last name followed by first name, separated with a comma, and have the column header"Name." The city and state should be listed as one column in the output, with the values separated by a comma and the column header"Location." Display the customers whose region begins with the letter 'N'. 2. Display the book title and category for all books in the Self Help and Family Life categories. Create three different queries to accomplish this task: a) a search pattern operation, b) a logical operator, and c) another operator not used in a or b. 3. To determine the percentage of profit for a particular item, subtract the item's cost from the retail price to calculate the dollar amount of profit, and then divide the profit by the item's cost. The solution is then multiplied by 100 to determine the profit percentage for each book. Use a SELECT statement to display each book's title and percentage of profit. For the column displaying the percentage, use "Profit%" as the column heading. 4. List all information for each order that placed order in multiple quantities. Include an item total which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading "item Total" in the output 5. A customer service representative is trying to identify all books in the Computer or Children categories and published by Publisher 1 or Publisher 3. However, the results shouldn't include any book selling for less than $65.00. 6. Display the orders which were shipped the same day as they were ordered List the necessary fields to make outout understandable. Naming document: firstname_db_assgn1.doc 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 customer's name should be listed in order of last name followed by first name, separated with a comma, and have the column header"Name." The city and state should be listed as one column in the output, with the values separated by a comma and the column header"Location." Display the customers whose region begins with the letter 'N'. 2. Display the book title and category for all books in the Self Help and Family Life categories. Create three different queries to accomplish this task: a) a search pattern operation, b) a logical operator, and c) another operator not used in a or b. 3. To determine the percentage of profit for a particular item, subtract the item's cost from the retail price to calculate the dollar amount of profit, and then divide the profit by the item's cost. The solution is then multiplied by 100 to determine the profit percentage for each book. Use a SELECT statement to display each book's title and percentage of profit. For the column displaying the percentage, use "Profit%" as the column heading. 4. List all information for each order that placed order in multiple quantities. Include an item total which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading "item Total" in the output 5. A customer service representative is trying to identify all books in the Computer or Children categories and published by Publisher 1 or Publisher 3. However, the results shouldn't include any book selling for less than $65.00. 6. Display the orders which were shipped the same day as they were ordered List the necessary fields to make outout understandable
