Filter Assignments

These are the basic building blocks used in SELECT queries to retrieve and filter data from a table. The FROM clause specifies which table the data is coming from, while the WHERE clause is used to apply conditions (constraints) to filter records before they are returned. Functions like COUNT(column_name) help count the total number of values in a column, and COUNT(DISTINCT column_name) is used to count only unique values. String functions such as LEFT(column_name, n) are useful for extracting characters from the beginning of a column value, often used in conditions to filter records based on starting letters or patterns. Together, these elements form the foundation of writing effective SQL queries for data retrieval and analysis. 1.Get all movies (films) that have a rental rate greater than $3. SELECT title, rental_rate FROM film WHERE rental_rate > 3; 2.Get all movies that have a rental rate greater than $3 and a replacement cost less than $20. SELECT title, rental_rate, replacement_