2 Use the Case function when then From the Invoices table s

2. Use the Case function – when then…. From the Invoices table, select the VendorID and InvoiceTotal. Create another column called ‘High or Low’. When the InvoiceTotal is greater than 100 then ‘High’. When it is less than or equal to 100, then populate your new column with ‘Low’.

Solution

Select VendorId,InvoiceTotal,

CASE WHEN InvoiceTotal > 100 THEN \'High\'

CASE WHEN InvoiceTotal <= 100 THEN \'Low\'

END As \"High or Low\"

From Invoices;