What is the billing city for the customer with ID number 28

From the following table, write a SQL query to find all the customers. Sort the result-set by customer_id. Return cust_name, city, grade.

Sample table: customer

Sample Solution:

Output of the Query:

Relational Algebra Expression:

Relational Algebra Tree:

Explanation :

Pictorial presentation :

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous SQL Exercise: Oldest orders first on the highest purchase amount.
Next SQL Exercise: Salesman details by smallest ID along with order date.