INSERT INTO students (
    student_first_name,
    student_last_name,
    student_course
)
VALUES (?, ?, ?);

SELECT *
FROM students
ORDER BY student_id DESC;

SELECT *
FROM students
WHERE student_id = ?;

UPDATE students
SET
    student_first_name = ?,
    student_last_name = ?,
    student_course = ?
WHERE student_id = ?;

DELETE FROM students
WHERE student_id = ?;

INSERT INTO books (
    book_title,
    book_author,
    book_category
)
VALUES (?, ?, ?);

SELECT *
FROM books
ORDER BY book_id DESC;

SELECT *
FROM books
WHERE book_id = ?;

UPDATE books
SET
    book_title = ?,
    book_author = ?,
    book_category = ?
WHERE book_id = ?;

DELETE FROM books
WHERE book_id = ?;

INSERT INTO borrow (
    student_id,
    book_id
)
VALUES (?, ?);

SELECT
    borrow.borrow_id,
    borrow.borrow_date,
    borrow.borrow_return_date,

    students.student_first_name,
    students.student_last_name,

    books.book_title,
    books.book_author

FROM borrow

INNER JOIN students
    ON borrow.student_id = students.student_id

INNER JOIN books
    ON borrow.book_id = books.book_id

ORDER BY borrow.borrow_id DESC;

UPDATE borrow
SET borrow_return_date = CURRENT_TIMESTAMP
WHERE borrow_id = ?;

DELETE FROM borrow
WHERE borrow_id = ?;