Filtering & Sorting Data using SQL Once you know the basics ( SELECT , FROM , WHERE ), filtering and sorting helps you get the exact rows from tables . 1. Filtering with Conditions ( AND , OR , NOT ) - Use WHERE to filter rows. - Combine with logical operators : • AND: all conditions true • OR: any condition true • NOT: negate condition - - All conditions true (AND) SELECT * FROM employees WHERE department = 'Sales' AND salary > 50000; -- Any condition true (OR) SELECT * FROM employees WHERE department = 'Sales' OR department = 'Marketing'; -- Negate condition (NOT) SELECT * FROM employees WHERE NOT department = 'HR'; 2. Pattern Matching with LIKE - % = any sequence, _ = single char • Names starting with 'J' • Names with 4 letters starting with 'J' - - N...