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