Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQLqueries 3. List FirstName, LastName and Email for all the salespeople in tblSalesperson Use aliases to display FirstName as First and LastName As Last 1
SQLqueries
3. List FirstName, LastName and Email for all the salespeople in tblSalesperson Use aliases to display FirstName as First and LastName As Last 1 2 3 First Last Email Walter Smith wsmith@gmail.com Eddie Rogers erogers@gmail.com Angela Wyatt awyatt@gmail.com Aaron Black ablack@gmail.com Samuel Hamis shamis@gmail.com Brian Smith bsmith@gmail.com James Patterson jpatterson@gmail.com 4 5 6 IJ o southalabama.edu/courses/14019/assignments/268800 4. List LastName and FirstName for all the salespeople in tblSalesperson Use aliases to display FirstName as First Name and LastName As Last Name (with spaces between the two words for both columns) Order your results by LastName in descending order Last Name First Name Wyatt Angela 2 Smith Walter 13 Smith Bran Rogers Eddie 5 Patterson James Hams Samuel Baron Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started