Apply Filters to SQL Queries

Project summary

The project focused on creating SQL queries to filter data about logins and employees. The log_in_attempts and employees tables were used, applying logical operators (AND, OR, NOT) and patterns (LIKE) for precise information retrieval.

The main tasks included:

• Searching for failed logins after business hours.

• Analyzing logins from specific dates (e.g., May 9, 2022).

• Identifying logins from outside Mexico.

• Filtering employee data in the Marketing, Finance, and Sales departments, as well as excluding individuals from IT.