https://www.sqlprostudio.com/
https://www.araelium.com/querious
https://www.navicat.com/en/products
which of these 👆🏾 do Entity Relationshiop diagrams?
**SQL**, or _Structured Query Language_, is a language to talk to databases. It allows you to select specific data and to build complex reports. Today, SQL is a universal language of data. It is used in practically all technologies that process data.
## Sample Data
### Country
| id | name | population | area |
|----|---------|------------|--------|
| 1 | France | 66600000 | 640680 |
| 2 | Germany | 80700000 | 357000 |
### City
| id | name | country_id | population | rating |
|----|---------|------------|------------|--------|
| 1 | France | 1 | 2243000 | 5 |
| 2 | Germany | 2 | 3460000 | 3 |
## Querying Single Table
Fetch all columns from the country table
```sql
SELECT *
FROM country;
```
Fetch id and name columns from the city table
```sql
SELECT id, name
FROM city;
```
Fetch city names sorted by the rating column in the default ASCending order:
```sql
SELECT name
FROM city
ORDER BY rating [ASC];
```
Fetch city names sorted by the rating column in the DESCending order:
```sql
SELECT name
FROM city
ORDER BY rating DESC;
```