Hi! 🤓 I am trying to write following stored procedure/function in SQL:

DECLARE count_rows;
SELECT COUNT(*) as count_rows FROM customers;
INSERT INTO customers (first_name, last_name, delivery_order)
VALUES (
  first_name,
  last_name,
  count_rows
);

Following message appear: Error: syntax error at or near ";" I would be happy for any suggestions 🙂

Fixed it!

INSERT INTO customers (first_name, last_name, delivery_order)
VALUES (
  first_name,
  last_name,
  (SELECT COUNT(*) FROM customers)+1
);