From the schema table:

In my SQL

83 RROR 1846 (300e0) No database selected ysql> use invoice atabase changed ysql> desc invoices; Field Type | Null | Key | Default | Extra PRI I NULL NULL NULL NULL NULL 0.00 0.00 NULL NULL NULL l invoice id auto increment NO NO invoice_number varchar(5) NO NO decimal(9,2) NO l decimal(9,2) NO l decimal(9,2) NO NO NO vendor id int (11) date invoice date invoice total | payment_total I credit total | terms id int (11) invoice due date date date payment date YES 16 rows in set (6.80 sec) ysql> selectfrom invoices; invoice id vendor_id | invoice number | invoice date invoice total payment total | credit total terms id invoice due date | payment date | 32 AX-014-027 32 AX-014-027 2014-88-01 2014-88-01 434.58 434.58 2 2014-88-31 2 2014-88-31 NULL NULL rows in set (0.80 sec) ysql> selectfrom invoices where balance due > 5e; RROR 1054 (42S22): Unknown column balance due in where clause ysql> select from invoices where invoice total se; invoice id vendor id | invoice number | invoice date invoice total | payment total | credit total | terms id invoice due date payment date | 32 AX-014-027 32 | AX-014-027 | 2814-88-e1 2014-08-01 434.58 434.58 2 2814-88-31 2 2014-08-31 NULL NULL rows in set (.05 sec) ysql> slectfrom invoices order by invoice totl> 5e; l invoice_id | vendor_id | invoice_number | invoice_date | invoice total I payment_ total | credit_total | terms id | invoice_due_date | payment_date 32 AX-014-827 32 AX-014-027 | 2814-88-81 2014-88-81 434.58 434.58 2 2014-88-31 2 I2814-88-31 NULL NULL rows in set (e.05 sec) ysql