+1 (315) 557-6473 

Create a Program to Formulate Commands in SQL Assignment Solution.


Instructions

Objective
Write a program to formulate commands in sql language.

Requirements and Specifications

program to formulate commands in sql

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);