CIS$276$DB

Module $3$ Assignment

$1.$ Write a select statement that returns all rows from the Vendors

table.

$2.$ Write a select statement that returns the InvoiceNumber,

InvoiceDate and InvoiceTotal

columns from the Invoice table

$3.$ Write a select statement that returns the VendorName, VendorCity,

VendorState and

VendorPhone columns from the Vendors table. Alias the following

columns:

VendorState $($State$),$ VendorCity $($City$)$ and VendorPhone $($Phone$).$

$4.$ Write a select statement that returns InvoiceNumber and a

calculated column aliased

as BalanceDue from the Invoice Table $($balance is calculated as follows:

InvoiceTotal

minus PaymentTotal minus CreditTotal$).$

$5.$ Write a select statement that returns the top $30$ percent from the

Invoice table. Include

the following columns: InvoiceNumber, InvoiceDate and InvoiceTotal.

$6.$ Write a select statement that returns VendorName,

VendorContactFName,

VendorContactLName from the Vendors table. Alias the following

columns: