CREATE DATABASE mydatabase;

CREATE TABLE users (
  id INT PRIMARY KEY,
  username VARCHAR(50),
  email VARCHAR(100)
);

INSERT INTO users (id, username, email)
VALUES (1, 'john_doe', '[email protected]');

SELECT * FROM users;

SELECT * FROM users WHERE username = 'john_doe';

SELECT * FROM users ORDER BY username ASC LIMIT 10;

SELECT COUNT(*) FROM users; # Use aggregate functions like COUNT, SUM, AVG, MIN, and MAX for data analysis

UPDATE users SET email = '[email protected]' WHERE id = 1;

DELETE FROM users WHERE id = 1;

SELECT users.username, orders.order_id
FROM users
INNER JOIN orders ON users.id = orders.user_id;

ALTER TABLE table_name ADD column_name datatype;

DROP TABLE table_name;

SHOW DATABASES; # Displays a list of all the available databases

SHOW SCHEMAS; # an alternate for the SHOW DATABASES statement

USE database_name; # Specifies which database to use

SHOW TABLES; # Displays a list of tables in the current database