UPDATE customers SET email = '[email protected]' where id = 3;

DELETE from customers where id = 4;

ALTER TABLE customers MODIFY COLUMN testCol int(11);

ALTER TABLE customers DROP testCol;

SELECT * from customers;

SELECT first_name, last_name FROM customers;

SELECT * FROM customers WHERE id = 2;

SELECT * FROM customers ORDER BY last_name;

SELECT DISTINCT state FROM customers;

SELECT * FROM customers WHERE age < 30;

SELECT * FROM customers WHERE city like '%chi%';

SELECT * FROM customers WHERE state IN ('il') CREATE INDEX Cindex ON customers(city);

CREATE TABLE orders ( id INT NOT NULL AUTO_INCREMENT, orderNUMBER INT, productID INT, customerID INT, orderDate DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(id), FOREIGN KEY(customerID) REFERENCES customers(id), FOREIGN KEY(productID) REFERENCES products(id) )

SELECT customers.first_name, customers.last_name, orders.orderNUMBER FROM customers INNER JOIN orders ON customers.id = orders.customerID ORDER BY customers.last_name;

SELECT customers.first_name, customers.last_name, orders.orderNUMBER, orders.orderDate FROM customers LEFT JOIN orders ON customers.id = orders.customerID ORDER BY customers.last_name

SELECT orders.orderNUMBER, customers.first_name, customers.last_name FROM orders RIGHT JOIN customers ON orders.customerID = customers.id ORDER BY orders.orderNUMBER

SELECT orders.orderNUMBER, customers.first_name, customers.last_name, products.name FROM orders INNER JOIN products ON orders.productID = products.id INNER join customers ON orders.customerID = customers.id ORDER BY orders.orderNUMBER;

SELECT CONCAT(first_name, ‘ ‘, last_name) AS ‘Name’, address, city, state FROM customers;

Ex: FROM customers AS c, orders AS o

SELECT AVG(age) FROM customers

SELECT COUNT(age) FROM customers

SELECT SUM(age) FROM cusomers

Ex: If we were looking to group customers by age

SELECT age, COUNT(age) FROM customers WHERE age > 30 GROUP BY age;