Requirements will be provided in attachments. Write SQL queries to satisfy each requirement given. Make sure the tables are correctly created and function properly. Must use Microsoft SQL Server...

77705/AnswersScreenShot.docx
Answer1
Answer 2
Answer3
Answer 4
Answer 5
Answer 6
Answer 7
Answer 8
Answer 9
Answer 10
77705/ScreenShots/answer1.JPG
77705/ScreenShots/answer10.JPG
77705/ScreenShots/answer2.JPG
77705/ScreenShots/answer3.JPG
77705/ScreenShots/answer4.JPG
77705/ScreenShots/answer5.JPG
77705/ScreenShots/answer6.JPG
77705/ScreenShots/answer7.JPG
77705/ScreenShots/answer8.JPG
77705/ScreenShots/answer9.JPG
77705/SQLQuery1.sql
---Answer 1:
SELECT VendorName, CONCAT(VendorCity,',' ,VendorState,',', VendorZipCode) as FullAddress
FROM vendors WHERE
vendorname like 'a%'
or vendorname like 'b%'
or vendorname like 'c%'
or vendorname like 'e%'
or vendorname like 'h%'
ORDER BY VendorName,VendorState
---Answer 2:
SELECT InvoiceID,
InvoiceTotal,
(InvoiceTotal - PaymentTotal - CreditTotal) as BalanceDue,
(1.15 * InvoiceTotal) AS 'Plus 15%',--Plus 15% is .15*InvoiceTotal +InvoiceTotal which is (1.15* InvoiceTotal)
(.80*(1.15 *...