attempt=783586&cmid=325138 Um WSIACC wangu u EUDU Wag ut AAUP Super Market Customer Name AB Discount Price after discount Quantky 3 1 2 Osama Muna Ahmad Mohammad Ahmad Alio Ahmad Product ID Product Name 201012 Orange Juice 201013 Chocolate 201014 Doritos chips 201012 Orange Juice 201014 Doritos chips 201017|Candy 201013 Chocolate 201013 Chocolate Total Price 15 3 3 5 12 25 18 21 1 3 Your Name 2 6 7 Answer the following Questions: 1. Add a column to the table (called Customer ID), that must contain a customer id for every customer. 2. Find the average of Total Prices. 3. The sum of Total price of Products purchased by customers with name "Ahmad". 4- The average of Sales (Total price) of products with the product ID=201214. 5- In Discount column: If the customer purchases less than 3 quantities of any product, he does not receive any discount 0% discount, and if he buys 3 to 5 quantities of the products, he receives a discount of 3% from the total price of the purchases, and if he purchases 6 to 7 quantities, he receives a 5% discount from the total price, and if he buys more than 8 quantities of the products, he receives a discount of 10% from the total price of the purchases 6- Find the average of Prices after discount. 7. Price after discount (total price - discount)-2. 8. Highlight the Total price If the total price is less than 5. paint it red, and the total price 10. its color yellow, and if it is greater than 20. its color red. 9. The Customer ID must be a number of less than 999999 and more than 200000. 10-Draw a graph showing the relationship between the customer's id and the price of their purchases quantities attempt=783586&cmid=325138 Um WSIACC wangu u EUDU Wag ut AAUP Super Market Customer Name AB Discount Price after discount Quantky 3 1 2 Osama Muna Ahmad Mohammad Ahmad Alio Ahmad Product ID Product Name 201012 Orange Juice 201013 Chocolate 201014 Doritos chips 201012 Orange Juice 201014 Doritos chips 201017|Candy 201013 Chocolate 201013 Chocolate Total Price 15 3 3 5 12 25 18 21 1 3 Your Name 2 6 7 Answer the following Questions: 1. Add a column to the table (called Customer ID), that must contain a customer id for every customer. 2. Find the average of Total Prices. 3. The sum of Total price of Products purchased by customers with name "Ahmad". 4- The average of Sales (Total price) of products with the product ID=201214. 5- In Discount column: If the customer purchases less than 3 quantities of any product, he does not receive any discount 0% discount, and if he buys 3 to 5 quantities of the products, he receives a discount of 3% from the total price of the purchases, and if he purchases 6 to 7 quantities, he receives a 5% discount from the total price, and if he buys more than 8 quantities of the products, he receives a discount of 10% from the total price of the purchases 6- Find the average of Prices after discount. 7. Price after discount (total price - discount)-2. 8. Highlight the Total price If the total price is less than 5. paint it red, and the total price 10. its color yellow, and if it is greater than 20. its color red. 9. The Customer ID must be a number of less than 999999 and more than 200000. 10-Draw a graph showing the relationship between the customer's id and the price of their purchases quantities
