This is the project that I created by following the class - a database called Company and various scripts.

The database consists of four tables - Customers, Months, Orders and Subscriptions.

Fig. 1: Table Customers.

SQL Business Database Demo - image 2 - student project

Fig. 2: Table Months.

SQL Business Database Demo - image 3 - student project

Fig. 3: Table Orders.

SQL Business Database Demo - image 4 - student project

Fig. 4: Table Subscriptions.

I wrote scripts that:

create and manage tables (also temporary tables),
select, order and filter records (including the NULL filter, clauses: BETWEEN, AND, OR, LIMIT, CASE),
use:
- wildcards,
- aggregate functions,
- joins and unions.

SQL Business Database Demo - image 5 - student project

Fig. 5: Script creating a temporary table.

SQL Business Database Demo - image 6 - student project

Fig. 6: Results of executing the script in Fig. 5.

Ola7117

--