Question: Based on Figure 4, write an SQL coding for the following questions. Table : CUSTOMER Table: VENDOR CCode 10010 10011 10012 10013 10014 CName Abu

 Based on Figure 4, write an SQL coding for the following
questions. Table : CUSTOMER Table: VENDOR CCode 10010 10011 10012 10013 10014

Based on Figure 4, write an SQL coding for the following questions. Table : CUSTOMER Table: VENDOR CCode 10010 10011 10012 10013 10014 CName Abu Joji Ramu Gopi Sally Cinitial A J R G S CBalance 0.00 0.00 345.86 536.75 221.19 VCode VName VState 21225 Bryson, Inc. TN 21226 Super, Inc. FL 21231 My Supply TN 21344 Dina Supply KY 22567 Green Tech GA 23119 Abc System GA 24004 Padu, Inc. FL Table : PRODUCT PCode PCode PDescript V Code 112 111 Hammer 21231 112 112 Screw 24004 114 113 Cloth 21344 113 114 PVC Pipe 21225 Table : LINE Table : IN INVOICE INum CCode IDate 001 10011 16-Jan-18 10014 17-Jan-18 003 10013 16-Jan-18 002 INum LNum 001 1 2 002 1 003 3 002 List CName, IDate and PDescription for CBalance is more than 200. (6 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!