Program to Formulate Commands in SQL Assignment Solution.

Instructions

Objective

Write a program to formulate commands in sql language.

Requirements and Specifications

Source Code

Question 1

SELECT
VendorContactFName, VendorContactLName, VendorName
FROM Vendors
ORDER BY VendorContactLName, VendorContactFName;

Question 2

SELECT
InvoiceNumber AS Number,
InvoiceTotal AS Total,
PaymentTotal + CreditTotal AS Credits,
InvoiceTotal - (PaymentTotal + CreditTotal) AS Balance
FROM Invoices;

Question 3

SELECT
VendorContactLName + ', ' + VendorContactFName AS [Full Name]
FROM Vendors
ORDER BY VendorContactLName, VendorContactFName;

Question 4

SELECT
InvoiceTotal, InvoiceTotal / 10 AS [10%],
InvoiceTotal * 1.1 AS [Plus 10%]
FROM Invoices
WHERE InvoiceTotal - PaymentTotal - CreditTotal > 1000
ORDER BY InvoiceTotal DESC;

Question 5

SELECT
InvoiceNumber AS Number,
InvoiceTotal AS Total,
PaymentTotal + CreditTotal AS Credits,
InvoiceTotal - (PaymentTotal + CreditTotal) AS Balance
FROM Invoices
WHERE InvoiceTotal >= 500 AND InvoiceTotal <= 10000;

Question 6

SELECT
VendorContactLName + ', ' + VendorContactFName AS [Full Name]
FROM Vendors
WHERE VendorContactLName LIKE '[A-E]%' AND VendorContactLName NOT LIKE 'D%'
ORDER BY VendorContactLName, VendorContactFName;

Question 7

SELECT *
FROM Invoices
WHERE ((InvoiceTotal - PaymentTotal - CreditTotal <= 0) AND
PaymentDate IS NULL) OR
((InvoiceTotal - PaymentTotal - CreditTotal > 0) AND
PaymentDate IS NOT NULL);

Create a Program to Formulate Commands in SQL Assignment Solution.

Instructions

Requirements and Specifications