====== Advanced SQL Queries ======


==== Filtering Data with WHERE ====

<code>
SELECT * FROM users WHERE email = 'john@example.com';
</code>

Filters records based on the given condition.

==== Using Logical Operators ====

<code>
SELECT * FROM users WHERE email = 'john@example.com' AND name = 'John Doe';
</code>

This fetches records matching both conditions.

==== Sorting Results ====

<code>
SELECT * FROM users ORDER BY created_at DESC;
</code>

Sorts records in descending order by creation date.

==== Updating Data ====

<code>
UPDATE users SET name = 'Jane Doe' WHERE id = 1;
</code>

Updates the name of a user with ID 1.

==== Deleting Data ====

<code>
DELETE FROM users WHERE id = 1;
</code>

Deletes the record where the ID is 1.

==== Using Joins ====

<code>
SELECT users.name, orders.amount FROM users
JOIN orders ON users.id = orders.user_id;
</code>

This retrieves user names along with their order amounts by joining users and orders tables.