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.

Fig. 2: Table Months.

Fig. 3: Table Orders.

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.

Fig. 5: Script creating a temporary table.

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