﻿ SQL Formatting Output: Display customer name, city, grade (according to the smallest ID) - w3resource

# SQL Exercises: Display customer name, city, grade (according to the smallest ID)

## SQL Formatting Output: Exercise-6 with Solution

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:

``````SELECT cust_name,city,grade
FROM customer
ORDER BY customer_id;
``````

Output of the Query:

```cust_name	city		grade
Nick Rimando	New York	100
Jozy Altidor	Moscow		200
Fabian Johnson	Paris		300
Graham Zusi	California	200
Julian Green	London		300
Geoff Cameron	Berlin		100```

Relational Algebra Expression:

Relational Algebra Tree:

Explanation :

Pictorial presentation :

## Query Visualization:

Duration:

Rows:

Cost:

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

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

﻿

## SQL: Tips of the Day

How to restore a dump file from mysqldump?

It should be as simple as running this:

```mysql -u <user> -p < db_backup.dump
```

If the dump is of a single database you may have to add a line at the top of the file:

```USE <database-name-here>;
```

Ref: https://bit.ly/3xKmyw2