DB_Queries - Section 3 - Dat Nguyen

DB_Queries - Section 3 - Dat Nguyen - DB Queries Project...

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

View Full Document Right Arrow Icon
DB Queries Project Student Name: Dat Nguyen Section Number: 3 1. Jungpil Lee was the most recently hired. Query1 SalesID SalesFirstName SalesLastName SalesHireDate 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. 13 records are in the result. Query2 CustomerFirstName CustomerLastName Martin March Pablo Martinez Ahmed Marwan Leticia Mauer Lola McCloud James McKinney Glenn McMahon Mark Mead Taylor Merrill Susanna Miner Elizabeth Mitchell Allen Mosely Isabella Munoz 3. 43 customers with annual incomes greater than $80,000 purchased cars from salesperson “Jesse” Query3 CustomerFirstName CustomerLastName AnnualIncome Robin Webb $90,375.00 Kristi Fisher $103,250.00 George Campbell $80,250.00 Natasha Birmingham $90,500.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
Query3 CustomerFirstName CustomerLastName AnnualIncome
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

DB_Queries - Section 3 - Dat Nguyen - DB Queries Project...

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

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