SQL Query Examples for Different Databases and Use Cases

Sales Order Database

Use the Sales Order Database Provide a result set of the customers’ first and last name and their phone number for all customers who have ordered clothing. Make sure duplicate values are not included in the result set. Provide a result set of the product’s name and quantity on hand for all products that have not been ordered. Provide a result set of the employees’ first and las name for all employees that have sold accessories. Be sure not to include duplicates in your result set. Sort the result set in alphabetical order by employee last name. Provide a result set of the product’s name and description for all products ordered by a vendor that has a name that has ‘bike’ somewhere in their name. Provide the name of the product that is the most expensive we sell which is purchased from ProFormance. Provide a result set of the product names we sell that are purchased from a vendor that does not have a Web page. Provide a result set of the vendor name of all the vendors that sell us products that are bikes. Use Entertainment Agency Database Provide a result set of all the entertainer’s stage name and the count of the entertainer’s engagements. Provide a result set of all the customer’s first and last name that have a preference for salsa, and have booked an engagement. Make sure there is no duplicate values in the result set. Provide a result set of entertainer’s stage name who have played an engagement for customers from Bellevue. Make sure there are no duplicate values in the result set. Provide a result set of the entertainer’s stage name for all entertainers who have not been booked to an engagement. Use School Scheduling Database Provide a result set of all the first and last names of the staff members and the count that each teaches. Provide the first and last name of the students enrolled in a class that begins at 11 am. Sort the result set by student’s last name in alphabetical order. Provide a result set of all the first and last names of the faculty who teach in a classroom without a phone being available. Make sure there are no duplicate values in the result set. Provide a result set of all student’s first and last names that attend a class in a classroom that has a capacity > 80. Use Bowling League Database Provide a result set of the first and last name of the bowlers with a count of the games each bowled. Provide a result set of the first and last name of the bowlers that have bowled a game with a raw score of 200 or more. Please remove duplicates from the result set, and sort the result set in alphabetical order by last name. Provide a result set of the team name and a count of the number of matches the team has won. Use Recipes Database Provide a result set of the types of recipes and the count of recipes in each type. Sort the result set in descending alphabetical order. Provide a result set of the recipe titles for all recipes that have any of their measurements that use ‘to taste’. Directions for Submitting Your Assignment Name your Assignment document according to this convention: First and Last Name (use your own name of course). Submit your completed Assignment to the Unit 5 Dropbox by the deadline.