Program to Formulate Commands in SQL Assignment Solution.

Instructions

Objective

In this program, we will focus on constructing SQL commands for tasks like creating tables, inserting data, querying information, updating records, and deleting data. Our expert team is proficient in SQL and can guide you through various concepts, including database design, normalization, and optimization. Whether you are a beginner or need advanced SQL assignment help, we can provide tailored solutions to meet your specific requirements.

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