JavaScript Example:

-- Create the database
                CREATE DATABASE IF NOT EXISTS bookshopDB;
                USE bookshopDB;
                
                -- Create books table
                CREATE TABLE books (
                  book_id INT AUTO_INCREMENT PRIMARY KEY,
                  title VARCHAR(100),
                  author VARCHAR(100),
                  price DECIMAL(10,2),
                  available_copies INT
                );
                INSERT INTO books (title, author, price, available_copies)
                VALUES
                ('Book A', 'Author A', 250.00, 10),
                ('Book B', 'Author B', 500.00, 5),
                ('Book C', 'Author C', 1000.00, 2),
                ('Book D', 'Author D', 750.00, 7),
                ('Book E', 'Author E', 300.00, 15);
                SELECT * FROM books;
                ALTER TABLE books
                PARTITION BY RANGE (available_copies) (
                  PARTITION p1 VALUES LESS THAN (5),
                  PARTITION p2 VALUES LESS THAN (10),
                  PARTITION p3 VALUES LESS THAN MAXVALUE
                );