Provide 1 .sql file that gives the SQL select statements that need to be used to
ID: 3855029 • Letter: P
Question
Provide 1 .sql file that gives the SQL select statements that need to be used to get the following results. Use the AP database from the book databases. You should have this created already.
1. I want to send a flyer to all Vendors who currently have an invoice that isn't paid. Give me a result set that will allow me to do that.
2. I want to know all of the invoices that have more than 1 item.
3. I want to know all of the invoices with 30, 60 and 90 day terms.
Please write whole CODE out with the TABLE NAMES. IF they are not here inform me so that I may upload them. I need the statements with the Table Names in them.
dbo.ContactUpdates dbo.GLAccounts dbo.InvoiceArchive dbo.InvoiceLineltems ES dbo·Invoices dbo.Terms dbo.VendorsExplanation / Answer
1.
Select VendorID,VendorName from Vendors inner join Invoices on Vendors.VendorID = Invoices.VendorID where Invoices.PaymentDate IS NULL;
2.
Select * from Invoices inner join Items on Invoices.ItemID = Items.ItemID where count(Invoices.ItemID) > 1;
3.
Select * from Invoices inner join Terms on Invoices.TermsID = Terms.TermsID where Terms.TermsDueDate IN (30,60,90);
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.