Wondering if I could get a bit of help with this question: 2. Query “ Sales.Stor

Question

Wondering if I could get a bit of help with this question:

2. Query “Sales.Store” table to obtain the list of “Name” and “SalesPersonID” where the store name starts with the letters “g” through “j” and the SalesPersonID is greater than 283. Make sure that the list is sorted by “SalesPersonID” and then by “Name” fields in a descending order. Be sure the query returns all the required rows.

Submit the SQL statement used to accomplish this task.

How many rows were affected?

Provide a screenshot of the result set.

Hint: Combine WHERE clause conditions and also have an ORDER BY clause in place.

Explanation / Answer

Ans:

With and logic operator we will get satisified with the two conditions of desired result Sales.Store with ORDERBY clause also

Select SalesPersonID,Name from Sales.Store WHERE SalesPersonID>283 and Name=g%J% ORDER BY SalesPersonID,Name DESC;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.