0.22) Consider the following tables GARMENTS and FABRIC. Write SQL commands for the statements(i) to (iv) and give outputs for SQL queries(v) to(viii).
Table:GARMENT
GCODE
10023
10001
10012
10024
10090
10019
10009 10007
10020
DESCRIPTION
PENCIL SKIRT
FORMAL SHIRT
INFORMAL SHIRT
BABY TOP
TULIP SKIRT
EVENING GOWN
INFORMAL PANT
FORMALPANT
FROCK
Table: FABRIC
CODE
F04
FOZ
F03
FOI
TYPE
POLYSTER
COTTON
SILK
TEREUNE
PRICE
1150
1250
1550
750
850
850
1500 1350
850
FCODE
F03
F01
FO2
FO3
FD2
F03
FO2
F01
F04
FD3
READY DATE
19 DEC 08
12-JAN-08
06-JAN-08
07-APR-07
31-MAR 07
06-JUNE-08
20-OCT-08 09-MAR-08
09-SEP-07
20-OCT 03
Answers
Answered by
2
Answer:
1to 4
Explanation:
Similar questions