IT350__Unit1.docx IT350 Advanced Database Concepts IT350-01 Purdue University Global

Document Content and Description Below

IT350__Unit1.docx IT350 Advanced Database Concepts IT350-01 Purdue University Global Problem 1: Display the bike names and list prices for bikes costing $5,000 or more. Order the results in des... cending order based on the list price. Problem 2: Present a list of the bikes made by a company called “Haro” in alphabetical order. Problem 3: Select customer records for customers residing in the 14450 zip code Problem 4: List the first and last names of staff members whose manager is Mireya Copeland. Problem 5: The company is now selling bikes from a company called GT Bicycles. Enter a new record into the database to reflect this change Problem 6: Update the amount of stock for the bike with product_id = 198 at the store with store_id = 2. The new stock amount should be 20. Problem 7: Show bike names and the total sales amounts for transactions involving bikes costing $10,000 or more. The total sales amount is the product of the bike order item list price, quantity sold, and sale discount. Problem 8: Provide a distinct list of the states in alphabetical order where the companys customers reside. Problem 9: Display the full names of all staff personnel in First_Name, “ ” , Last_Name format. Use the built-in CONCAT() function for this query. Problem 10: Show the bikes that have zero stock at the Texas (TX) store. Reference . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .. .. . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [Show More]

Last updated: 1 year ago

Preview 1 out of 10 pages