**Course Title:** SQL Mastery: From Fundamentals to Advanced Techniques **Section Title:** Data Retrieval with SQL: SELECT Queries **Topic:** Write queries to filter, sort, and limit data from a sample database.(Lab topic) In this lab exercise, you will practice writing SQL queries to filter, sort, and limit data from a sample database. This hands-on experience will help you become more proficient in using SQL to retrieve data effectively. **Lab Objectives:** * Filter data using the WHERE clause with various conditions * Sort data using the ORDER BY clause * Limit the result set using the LIMIT and OFFSET clauses * Combine filtering, sorting, and limiting in a single query **Sample Database:** For this lab, we will use a sample database called "movies" that contains information about movies, including title, genre, release year, and rating. You can download the sample database from the following URL: [https://www.sql-ex.com/learn/db/example.php](https://www.sql-ex.com/learn/db/example.php). **Lab Exercises:** **Exercise 1: Filtering data** Write a SQL query to retrieve the titles of movies released after 2000. ```sql SELECT title FROM movies WHERE release_year > 2000; ``` **Exercise 2: Filtering data with multiple conditions** Write a SQL query to retrieve the titles of movies that are action movies and released after 2010. ```sql SELECT title FROM movies WHERE genre = 'Action' AND release_year > 2010; ``` **Exercise 3: Sorting data** Write a SQL query to retrieve the titles of movies sorted by release year in descending order. ```sql SELECT title FROM movies ORDER BY release_year DESC; ``` **Exercise 4: Limiting the result set** Write a SQL query to retrieve the first 10 movies with the highest rating. ```sql SELECT title, rating FROM movies ORDER BY rating DESC LIMIT 10; ``` **Exercise 5: Combining filtering, sorting, and limiting** Write a SQL query to retrieve the titles of action movies released after 2010, sorted by rating in descending order, and limited to the top 5 movies. ```sql SELECT title, rating FROM movies WHERE genre = 'Action' AND release_year > 2010 ORDER BY rating DESC LIMIT 5; ``` **Tips and Reminders:** * Use the WHERE clause to filter data based on conditions * Use the ORDER BY clause to sort data in ascending or descending order * Use the LIMIT and OFFSET clauses to limit the result set * Combine filtering, sorting, and limiting in a single query to retrieve specific data **Key Concepts:** * Filtering data using the WHERE clause * Sorting data using the ORDER BY clause * Limiting the result set using the LIMIT and OFFSET clauses * Combining filtering, sorting, and limiting in a single query **Practice and Apply:** Practice writing SQL queries to filter, sort, and limit data from the sample database. Experiment with different conditions, sorting options, and limiting options to become more proficient in using SQL to retrieve data effectively. **Additional Resources:** * W3Schools SQL Tutorial: [https://www.w3schools.com/sql/](https://www.w3schools.com/sql/) * SQL Tutorial by Tutorials Point: [https://www.tutorialspoint.com/sql/index.htm](https://www.tutorialspoint.com/sql/index.htm) **Leave a comment or ask for help:** If you have any questions or need help with any of the exercises, please leave a comment below. We'll be happy to assist you. In the next topic, we will cover 'Using aggregate functions: COUNT, SUM, AVG, MIN, MAX.' From: SQL Functions and Operators.