formal_quartz_4797

From products, return product_id, product_name, price where price is BETWEEN 20 AND 40

Find all products with a price between 20 and 80 (inclusive)

From products, return product_id, price, and a band column using CASE: 'cheap' if price < 20, 'mid'

From products, return product_id and product_name where product_name LIKE '%Pro%'

Find all transactions made between '2024-01-01' and '2024-06-30' where the total_amount is between 1

Show the 3rd through 5th most recent transactions by date

Find the 5 most expensive products

Find all search queries where the search_term does NOT start with 'SELECT'

Find all users whose email address ends with '.com'

Find transactions for user 100 or user 234, but only where either the quantity is at least 2 or the