> For the complete documentation index, see [llms.txt](https://cybersecurity-cloud-and-it-notes.gitbook.io/kyles-cybersecurity-cloud-and-it-gitbook/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://cybersecurity-cloud-and-it-notes.gitbook.io/kyles-cybersecurity-cloud-and-it-gitbook/google-cybersecurity-professional-cert/4.-linux-and-sql-tool-of-the-trade/module-4/more-sql-filters/activity-apply-more-filters-in-sql.md).

# Activity: Apply more filters in SQL

## Introduction

In this lab, you’ll apply more filters to SQL queries to retrieve information from a database. You’ll use common operators in SQL to filter by specific dates and times. You’ll be using the MariaDB shell to run your SQL queries. **Disclaimer:** For optimal performance and compatibility, it is recommended to use either **Google Chrome** or **Mozilla Firefox** browsers while accessing the labs.

## What you’ll do

You have multiple tasks in this lab: 

* Filter for login attempts made after a certain date
* Filter for login attempts made in a certain date range
* Filter for login attempts made at a certain time
* Filter for login attempts by ID

## Lab instructions

### **Start the lab**

Before you start, you can review the [Resources for completing SQL labs](https://www.coursera.org/learn/linux-and-sql/supplement/CUlen/resources-for-completing-sql-labs). Then from this page, click **Launch App**. A Qwiklabs page will open and from that page, click **Start Lab** to begin the activity!

*You may attempt this lab a maximum of 5 times, and you will have 60 minutes to complete this lab during each attempt.*

### **End the lab**

From within the lab, click **End Lab** to end your lab.

Additionally, sometimes you need to refresh your Coursera page in order for your progress to be registered. If you refresh this page after you complete your lab, the green check mark should appear.

**Best practices for completing labs:**

* Make sure your browser is up to date with the latest version.
* Make sure your internet connection is stable.
* After you complete the lab, leave the lab window open for at least 10 minutes in order to allow the system to record your progress.
* If you run into issues connecting to the lab, try logging into Coursera in an Incognito mode and completing the lab there.
* Review [Lab tips and troubleshooting steps](https://www.coursera.org/learn/linux-and-sql/supplement/fRHpj/lab-tips-and-troubleshooting-steps) for more information.

***

This course uses a third-party app, Activity: Apply more filters in SQL, to enhance your learning experience. The app will reference basic information like your name, email, and Coursera ID.