title: ORACLE APEX SQL WORKSHOP: Received ORA-00936: missing expression error on this code
body: <pre><code>INSERT INTO TRANSACTIONS (TRANSACTIONID, CUSTOMERID, EMPLOYEEID, TRANSACTIONDATE, STOREID)
  
  VALUES (SELECT MAX(TRANSACTIONID) + 1 FROM TRANSACTIONS, SELECT CUSTOMERID FROM CUSTOMER WHERE CUSTOMERNAME = 'Julia Forbes', SELECT EMPLOYEEID FROM EMPLOYEE WHERE EMPLOYEENAME = 'Heather Manning', '04/12/2022', SELECT STOREID FROM STORE WHERE STOREADDRESS LIKE '%Paso%')
  </code></pre>
  <p>Could you tell me what I may have done wrong here? I keep on receiving the error about the missing expression even though I tested this multiple times.</p>