Applied basic filters to SQL queries to retrieve information from a MariaDB database:
First, the analyst listed all organization machines and their operating systems.
Second, listed all machines with the operating system OS 2.
Third, listed all the employees in the Finance and Sales departments.
Finance:
Sales:
Finally, obtained information about machines.
Our team recently discovered that there are issues with machines in the South building. The analyst needed to obtain certain employee and computer information. A machine in 'South-109' has an issue. The analyst needed to determine which employee uses that computer so that an alert could be sent.
Soon after our team had determined that there was an issue with all the machines in the South building. Offices in the organization table are named with the building name, a hyphen, and the office number in that building The analyst performed a simple inquiry to return information on all the employees in the 'South' building
