I'm studying sql (by myself) and I would like to know how I would do for these examples:

1- i'd create this 3 tables bellow:

```
CREATE TABLE Business (
    Id INT,
    Category INT,
    Business_Name VARCHAR(30),
    City_Id INT,
    Billing INT
);
INSERT INTO business (Id, Category, Business_Name, City_Id, Billing) VALUES(1, 1, 'Bread', 1, 50);

INSERT INTO business (Id, Category, Business_Name, City_Id, Billing) VALUES(2, 2, 'Oreo', 2, 10);

INSERT INTO business (Id, Category, Business_Name, City_Id, Billing) VALUES(3, 2, 'Pizza', 3, 15);

INSERT INTO business (Id, Category, Business_Name, City_Id, Billing) VALUES(4, 2, 'Beer', 4, 25);

INSERT INTO business (Id, Category, Business_Name, City_Id, Billing) VALUES(5, 1, 'Steak', 1, 80);

CREATE TABLE City (
    Id INT,
    City_Name VARCHAR(30)
);

INSERT INTO City (Id, City_Name) VALUES(1, 'Paris');
INSERT INTO City (Id, City_Name) VALUES(2, 'New York');
INSERT INTO City (Id, City_Name) VALUES(3, 'Tokio');
INSERT INTO City (Id, City_Name) VALUES(4, 'Vancouver');

INSERT INTO City (Id, City_Name) VALUES(5, 'Cairo');

CREATE TABLE Category (
    Id INT,
    Category_Name VARCHAR(30)
 );

INSERT INTO Category (Id, Category_Name) VALUES(1, 'Bar');

INSERT INTO Category (Id, Category_Name) VALUES(2, 'Pub');

INSERT INTO Category (Id, Category_Name) VALUES(3, 'Pizza');

```

---

2- I want to make these SQL queries:

a) Total Value of Billing (Billing) all stores, like this table:

```
-----------------------
|Business_Name | Total |
|--------------+-------|
|Total         | 180   |
------------------------

```

b) All Total Billing by Category\_Name like this table:

```
-------------------
|Category | Total |
|---------+-------|
|Bar      | 130   |
|---------+-------|
|Pub      | 50    |
|---------+-------|
|Pizza    | 5     |
----------+--------

```

c)List the Business\_Name with min billing, showing the: Category\_Name, Business\_Name, and Billing like this table:

```
----------------------------------------
|Category_Name | Business_Name | Total |
|--------------+---------------+-------|
|Pub           | Beer          | 5     |
|--------------+---------------+--------

```

d) All Total of Billing by City, showing the: Category\_Name, Business\_Name, City\_Name and Billing like this table

```
--------------------------
|City            | Total |
|----------------+-------|
|Cairo           | 0     |
|----------------+-------|
|New York        | 10    |
|----------------+-------|
|Paris           | 130   |
|----------------+-------|
|Tokio           | 15    |
-----------------+--------
|Vancouver       | 25    |
-----------------+--------

```

Any body with a little more knowledge that could be help me, please? =)