SQL vs NoSQL Syntax

CREATE TABLE users (
user_id VARCHAR(20) NOT NULL,
age INTEGER NOT NULL,
status VARCHAR(10));

INSERT INTO users(user_id, age, status)
VALUES ('bcd001', 45,"A");

db.users.insert({
  user_id: "bcd001",
  age: 45,
  status: "A" 
})

SELECT *
FROM users;

db.users.find()

UPDATE users
SET status = 'C'
WHERE age > 25;

db.users.update(
    { age: { $gt: 25 } },
    { $set: { status: "C" } },
    { multi: true }
)

START TRANSACTION;
INSERT INTO orders 
(order_id, product, quantity)
VALUES ('1a2b3c', 'T-shirt', '7');
UPDATE stock
SET quantity=quantity-7
WHERE product='T-shirt';
COMMIT;

session.startTransaction();
db.orders.insert ({
  order_id: '1a2b3c',
  product: 'T-shirt',
  quantity: 7
})
db.stock.update (
  { product: { $eq: 'T-shirt', } },
  { $inc: { quantity: -7 } }
})
session.commitTransaction();