Code example 3-1 select vendorname, invoicenumber, invoicedate, invoicetotal from vendors inner join invoices on vendors .vendorid = invoices. vendorid where invoicetotal > = 500 order by vendorname desc how many columns will the result set have?

The correct answer for the given question is 4

Explanation:

In the given code it select the vendorName, invoiceNumber, invoiceDate, invoiceTotal from vendors ,invoices table. when required condition is fullfill i.e vendors .vendorID = invoices.vendorID and invoiceTotal >= 500 .

So their are 4 column in the result set i.e vendorName, invoiceNumber, invoiceDate, invoiceTotal .

answerhard disks;