You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

demo-queries-from slides-2.sql 538B

12345678910111213
  1. INSERT INTO invoices VALUES
  2. (115, 97, '456789', '2018-08-01', 8344.50, 0, 0, 1, '2018-08-31', NULL);
  3. INSERT INTO invoices
  4. (vendor_id, invoice_number, invoice_total, terms_id, invoice_date,
  5. invoice_due_date)
  6. VALUES
  7. (97, '456789', 8344.50, 1, '2018-08-01', '2018-08-31');
  8. INSERT INTO invoices VALUES
  9. (116, 97, '456701', '2018-08-02', 270.50, 0, 0, 1, '2018-09-01', NULL),
  10. (117, 97, '456791', '2018-08-03', 4390.00, 0, 0, 1, '2018-09-02', NULL),
  11. (118, 97, '456792', '2018-08-03', 565.60, 0, 0, 1, '2018-09-02', NULL);