My third project after completing a course in DQLab about fundamental SQL. I have completed the modules of fundamental SQL using the SELECT, FUNCTION, GROUP BY, INNER JOIN, UNION and Having. This project is provided by DQLab and uses MariaDB.

In this project, xyz.com will review the company’s performance during the last quarter. A data analyst is asked to provide data and analysis regarding the current condition of the company.

List of Tables

The tables that will be used in this project are:

Another project I worked on after completing a course in DQLab about fundamental SQL. I have completed the modules of fundamental SQL use SELECT statement, FUNCTION, GROUP BY, INNER JOIN, UNION and Having. This project is provided by DQLab and uses MariaDB.

1.1 Dataset Brief

The dataset used contains transactions from 2009 to 2012 with a total of raw data is 5500, including order status which is divided into order finished, order returned and order cancelled.

The dataset that will be used in this project contains the following data: 1. OrderID 2. Order Status 3. Customer 4. Order Date 5…

Finally, I have completed a course on DQLab about fundamental SQL in data analyst career track. I have completed the modules of fundamental SQL use SELECT statement, FUNCTION, GROUP BY, INNER JOIN, UNION and Having. Then, I worked on the first project provided by DQLab to apply the knowledge that I had learned. Here, the results of my first project.

Test SQL — MySQL Dialect

• Left Join

Consider the following two tables: