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...

1 answer below »
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 Management Studio. When finished, send back .sql file that contains all queries inMicrosoft SQL Server Management Studio, so I can screenshot the tables
Answered 4 days AfterMar 14, 2021

Answer To: Requirements will be provided in attachments. Write SQL queries to satisfy each requirement given....

Shweta answered on Mar 18 2021
131 Votes
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 *...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here