In the following exercises, you will use the data in the Premier Products database, which is posted on Bb. In each step, use SQL to obtain the desired results. You are to hand in the SQL commands for each step. You can use Access to help complete the steps, or you can simply write the SQL command to complete each step. Create an MS Word document and put the answers to each step in it. Submit this document to Bb along with your database for part 1.
List the number, name, and zip code of all customers.
List the complete Part table. Sort the result by part description in ascending order.
List the number and name of every customer represented by sales rep 35 or 65.
List the number and name of all customers that are represented by sales rep 35 and have credit limits of $10,000.
List the number and name of all customers that are represented by sales rep 35 or have credit limits of $10,000.
List all records of the Customer table where the zip code begins with 333.
Create a new table named SportingGoods to contain the columns PartNum, Description, OnHand, Warehouse, and Price for all rows in which the item class is SG.
In the SportingGoods table, change the description of part BV06 to “Fitness Gym”.
In the SportingGoods table, delete every row in which the price is greater than $1000.
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
Affordable prices
You might be focused on looking for a cheap essay writing service instead of searching for the perfect combination of quality and affordable rates. You need to be aware that a cheap essay does not mean a good essay, as qualified authors estimate their knowledge realistically. At the same time, it is all about balance. We are proud to offer rates among the best on the market and believe every student must have access to effective writing assistance for a cost that he or she finds affordable.
Caring support 24/7
If you need a cheap paper writing service, note that we combine affordable rates with excellent customer support. Our experienced support managers professionally resolve issues that might appear during your collaboration with our service. Apply to them with questions about orders, rates, payments, and more. Contact our managers via our website or email.
Non-plagiarized papers
“Please, write my paper, making it 100% unique.” We understand how vital it is for students to be sure their paper is original and written from scratch. To us, the reputation of a reliable service that offers non-plagiarized texts is vital. We stop collaborating with authors who get caught in plagiarism to avoid confusion. Besides, our customers’ satisfaction rate says it all.
