This uses the TAL Distributors database from MySQL.
Use the MySQL Workbench to create SELECT statements based on the requests below. Save the script file and upload to the link in Moodle. r Display customer contact information including customer number, customer name, and address information. 2. Display all of the customer information in the 90085 zip code. 3. Display the customers that have the word Gift as part of their name. 4. Display the customers that have the word Store as part of their name. 5. Display all of the customer information for all customers whose postal code starts with 901. 6. Display the customer name, city and balance for all customers with a balance $1000 or higher. 7 Display the customer name, city and balance for all customers with a balance less than $1,000. 8. Display the customer name, city and balance for all customers with a credit limit between 0 and $10,000. 9. Display customer name, balance and credit limit for all customers who have a balance that is greater than their credit limit 10. Display the Customer Information for the customers represented by Rep Num 15 and 45. 11. Display the item number, number ordered, quoted price and the total price for each item in the item table. 12. Display the description, category, price and amount on hand for each item in the Item table. 13. Display all of the information for sales rep number 30. 14. Display the rep number, rep first and last name, and commission value for the sales reps that have earned commissions of more than $25,000. 15. Display the Rep information including first name, last name, commission and total sales for each Rep. 16. Display the results of the last query, but only show total sales above $400,000.00. 17. Display the Item, description, on hand, category, price and inventory value for each item in the Item table. 18. Display the Item, description, price from the inventory table. Also include a mark up and retail price for each item assuming there is a 60% mark up for all items. 19. Display the item number, description, quantity on hand and price for the items that are priced $30.00 or less, 20. Display the item number, description, quantity on hand and price for the items that are priced $30.00 or more. 21. Display the item number, description, category and quantity on hand for all games. 22. Display the item number, description, category and quantity on hand for all puzzles. 23. Display the item number, description, category and quantity on hand for all toys. 24. Display item number, item name, category and price for all items that have a category of game and are less than $30.00 mber, item name, category and price for all items that have a category of puzzle and are less than $30.00 26. Display item number, item name, category and price for all items that are not toys. Display item number, item name, and amount on hand for the items that have less than 20 on hand. order the data by the on hand value. 28. Display the total on hand value for each category in the Item table. Order the results by category 29. Display item number, item name, and amount on hand for the items that have less than 20 on hand or are in storehouse 2. 30. Display item number, item name, and amount on hand for the items that have less than 5 on hand. 31. Display the Order line information for order number 51610. 32. Display the Order line information for order number 51617. 33. Display the Order line information for order number 51623. 34. Display the Order Number, Item Number, num ordered, Quoted Price and Total Price for each order. 35. Display the Order Number, Total of items ordered, and the Total Price for each order. 36. Display the Order Number, Total of items ordered, and the Total Price for each order for all orders with a Total Price greater than $350.00. 37. Display the Order Number, Total of items ordered, Total Price, Shipping and Grand Total for each order. Assume shipping charges are 5% of the total order. 38. Display the Order number, item number and number ordered for each order that includes item number FD11. 39. Display the Order Number and Order Date for all orders. 40. Display the Order Number and Order Date for all orders placed on or after 10/15/2015
