Complete the following tasks using your AP Database. Please submit 1 .doc file o

ID: 3849882 • Letter: C

Question

Complete the following tasks using your AP Database.

Please submit 1 .doc file of your SQL statements and a screen shot of a result set showing the data you inserted, updated, or deleted.

I want to change the data in the AP database according to the following requirements.

1. I need an additional payment term for Net due 120 days.

2. I need to delete the Vendor Jobtrak because it has never had an invoice.

3. The vendor Coffee Break Service has moved. The new address is 2325 Neil Armstrong Way Lebanon, OH 45036. The new number is (513) 555-5555.

4. The vendor Office Depot has changed default terms and the default account. They now have 120 days to pay and the default account is PC Software.

Please write the select statements for this please!! Need ASAP!

Yes, the field names and table names. You can use a generic one and I will do it in my SQL!

Thanks

Select * from table_name where sysdate-your_date_field=120

Delete from table_name where vendor_name='Jobtrak'

Update table_name set address= '2325 Neil Armstrong Way Lebanon, OH 45036', phone='(513) 555-5555' where vendor_name='Coffee Break Service'

Update table_name set default_term=120, default_account='PC Software' where vendor_name='Office Depot'