What You’ll Learn
- Creating and managing databases
- Writing SELECT, INSERT, UPDATE, DELETE queries
- Using WHERE, ORDER BY, and LIMIT
- Joining multiple tables
- Understanding primary keys and foreign keys
- Basic aggregate functions (COUNT, SUM, AVG, etc.)
SQL (Structured Query Language) is used to manage and manipulate databases. Whether you're building websites, apps, or data-driven systems, SQL is essential for interacting with stored data.
Write a query to find all customers who live in "New York" from a table named customers.
SELECT *
FROM customers
WHERE city = 'New York';