BASIC QUERIES FOR SQL

1. Movies with Rental Rate Greater Than 3 ```sql id="m1a2b3" SELECT * FROM film WHERE rental_rate > 3; This query returns all movies with a rental rate greater than 3. --- ## 2. Movies with Rental Rate Greater Than 3 and Replacement Cost Less Than 20 ```sql id="m2b3c4" SELECT * FROM film WHERE rental_rate > 3 AND replacement_cost < 20; This filters movies based on two conditions. 3. Movies Rated PG or Rental Rate 0.99 ```sql id="m3c4d5" SELECT * FROM film WHERE rating = 'PG' OR rental_rate = 0.99; This returns movies that match at least one condition. --- ## 4. First 10 Movies Sorted by Rental Rate Highest First ```sql id="m4d5e6" SELECT * FROM film ORDER BY rental_rate DESC LIMIT 10; This shows the top 10 movies with the highest rental rate. 5. Skip First 5 and Get Next 3 Movies ```sql id="m5e6f7" SELECT * FROM film ORDER BY rental_rate ASC OFFSET 5 LIMIT 3; This skips the first 5 records and returns the next 3. --- ## 6. Skip First 5 and Get Next 3 Movies ```sql id="m6f7g8"