Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How would you query the view to order the names by the employee's last name followed by the customer's last name, in alphabetical order? a

How would you query the view to order the names by the employee's last name followed by the customer's last name, in alphabetical order?
a.)
SELECT * FROM customer_support
ORDER BY emp_last_name, cust_last_name;
b.)
SELECT * FROM customer_support
ORDER BY emp_last_name DESC, cust_last_name DESC;
c.)
SELECT * FROM customer_support
ORDER BY cust_last_name ASC, emp_last_name ASC;
d.)
SELECT * FROM customer_support
ORDER BY cust_last_name, emp_last_name;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions