CREATE TABLE students (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  age INT,
  grade DECIMAL(3,1)
);

INSERT INTO students (name, age, grade) VALUES
  ('Alice', 20, 3.8),
  ('Bob', 22, 3.5),
  ('Charlie', 21, 3.9);


SELECT * FROM students 
WHERE age >= 21;

SELECT * FROM students 
WHERE age < 22;

SELECT * FROM students 
WHERE age < 22 AND name LIKE 'C%';

SELECT * FROM students 
ORDER BY age DESC;

SELECT * FROM students 
ORDER BY name DESC;

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: