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 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
Get step-by-step solutions from verified subject matter experts
