DB Queries ProjectSection 001

DB Queries ProjectSection 001 - DB Queries Project Section...

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

View Full Document Right Arrow Icon
DB Queries Project Section 001 1. Generate a list of salespeople and sort ascending by Sales Hire Data. Show Sales ID Sales First Name, Sales Last Name, Sales Hire Date and Sales Salary. Which Salesperson was most recently hired? From the query below, we can tell that Jungpil Lee was most recently hired. Query1 SalesI D SalesFirstNa me SalesLastNa me SalesHireDa te SalesSalary 1 Lewis Peoples 2/13/1989 $140,000.00 3 Juan Rodriguez 5/2/1989 $93,000.00 2 Richard Martin 5/2/1989 $82,000.00 4 Rachel Scholls 4/27/1996 $56,000.00 5 Jesse Lukes 5/15/1996 $67,000.00 6 Maggy Adelman 6/1/2001 $75,000.00 7 Dale Jones 11/9/2004 $71,000.00 8 Jungpil Lee 4/26/2006 $62,000.00 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? 3. Which customers with annual incomes greater than $80,000 purchased cars from Salesperson “Jesse”? Show first name, last name, and annual income of each of These customers. The following customers meet the search requirements: Query1 CustomerFirstNa me CustomerLastNa me AnnualInco me SalesFirstNa me Susanna Miner $120,250.00Jesse Lola McCloud $91,375.00Jesse Carl Hughes $115,625.00Jesse Martin March $96,125.00Jesse Helda Larsson $85,375.00Jesse Gloria Warden $121,625.00Jesse Maria Lariano $122,000.00Jesse Ivan Adolphsson $122,125.00Jesse Rafael Torrez $86,125.00Jesse Natasha Birmingham $90,500.00Jesse Zac Crookston $90,250.00Jesse
Background image of page 1

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

View Full DocumentRight Arrow Icon
Query1 CustomerFirstNa me CustomerLastNa me AnnualInco me SalesFirstNa me Devin Ralphs $103,875.00Jesse Kaleb Amherst $111,000.00Jesse Mason Richards $98,375.00Jesse Seth Romney $120,375.00Jesse Darnell Sutherland $84,000.00Jesse Anthony Leven $119,500.00Jesse Allen Mosely $86,125.00Jesse Bob Chapel $107,750.00Jesse Lauren Jorgenson $111,750.00Jesse Huan Kwong $97,375.00Jesse Omar Jabar $92,250.00Jesse Helen Fisher $85,250.00Jesse Paul Tarver $120,250.00Jesse Lara Thompson $97,750.00Jesse Ivan Smirnoff $95,500.00Jesse Samuel Larson $122,125.00Jesse William Austin $114,750.00Jesse Lucy Cluff $122,000.00Jesse Olivia Evans $90,250.00Jesse Robin Webb $90,375.00Jesse Anna Robinson $99,750.00Jesse Emma Gleave $88,500.00Jesse Kristi Fisher $103,250.00Jesse George Campbell $80,250.00Jesse Mack Wright $113,750.00Jesse Ed Wittmer $102,125.00Jesse Sue Rizzuto $124,375.00Jesse Angelina Grey $100,375.00Jesse Justin Neil $82,625.00Jesse Carmen Page $108,500.00Jesse Leticia Mauer $113,625.00Jesse Rosa Coleman $84,250.00Jesse 4. Which customers of salesperson “Rachel” financed vehicles with a “poor”, “very poor”, or “extremely poor” credit rating? Show the CreditDescription, first name, and last name of these customers.
Background image of page 2
Query1 CreditDescripti on CustomerFirstNa me CustomerLastNa me Extremely Poor Camilla Kelly Extremely Poor Camilla Kelly Extremely Poor Camilla Kelly Extremely Poor Camilla Kelly Extremely Poor Camilla Kelly Extremely Poor Camilla Kelly Extremely Poor Camilla
Background image of page 3

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

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

Page1 / 14

DB Queries ProjectSection 001 - DB Queries Project Section...

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

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