Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Apache Cassandra Development

Authors: Vivek Mishra

1st Edition

1484201426, 9781484201428

More Books

Students also viewed these Databases questions

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago