DB_Project

DB_Project - AFAS Build and Execute Queries Project (30...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
AFAS – Build and Execute Queries Project (30 Points) R: 9/21/09 In this project you will analyze AFAS practices using database queries. Download the full version of the “AFAS_Sales” database from the class website. This has more data in it than the database you created in the DB Build Follow-up Assignment. For each question below, create one query as a basis for the answer to each question. For each question, do the following: Type in the number of the question in Microsoft Word. Type your answer. Then paste the supporting query result after your answer. For some questions, the query result may also be the answer to the question. 1. Generate a list of salespeople and sort ascending by SalesHireData. Show SalesID SalesFirstName, SalesLastName, SalesHireDate and SalesSalary. Which salesperson was most recently hired? 2. Generate a list of which customers have a last name beginning with the letter “M”. Show the first and last names of these customers. Sort ascending by last name. How many records are in the result?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/17/2011.

Page1 / 2

DB_Project - AFAS Build and Execute Queries Project (30...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online