question.
- Q Write Postgresql For Below Question 1 (91.74 KiB) Viewed 38 times
Q. write PostgreSQL for below question.
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Q. write PostgreSQL for below question.
Q. write PostgreSQL for below
question.
CUSTOMERS CUSNO NAME CITY ST ZIP CRED OPEN $ YTD SALES ACT DT SLMN ID 0030 CANNON TOOLS CO ATLANTA GA A 3322123.00 34222 NY A 0090 0130 0150 INTERNATIONAL BANK CORP SUN DIAL CITRUS GROWERS NEW YORK LOS ANGELES 303012334 100059989 902130000 100190000 282552550 CA 21165 29390 A 860220 850815 850815 850815 850815 NEW YORK NY A 0170 CHARLOTTE NC A 23442.00 .00 21489.00 .00 .00 .00 .00 931.72 .00 13150 31420 17980 0190 CA A IMPERIAL BANKCORP UNITED ATLANTIC SHARES SOUTHWEST STATE OIL REFINING WEST LIFE INSURANCE CHEMICAL MUTUAL MICHIGAN LIGHTING INC. 850815 0210 SHERMAN OAKS BALTIMORE FORT WORTH MD A 00655 00725 TX A AZ A 914231423 212031203 761026102 850365036 181018101 303310331 940024002 968426842 850815 860220 850815 850815 850815 PA A PHOENIX ALLENTOWN ATLANTA SAN MATEO HONOLULU HARTFORD IRON WORKS INC NATIONAL HARRIS CORPORATION GA A 0230 0250 0270 0290 0310 0330 0350 0370 0390 0410 .00 .00 3457.00 .00 CA 18260 00760 00795 01075 18610 01145 А 211650.00 293900.00 131500.00 314200.00 179800.00 6550.00 7250.00 182600.00 7600.00 7950.00 10750.00 186100.00 11450.00 186450.00 187150.00 187850.00 190300.00 15650.00 16000.00 194850.00 204300.00 207100.00 HI A 850815 850815 850815 PORTLAND OR A A 850815 A CARTERET STEEL CORPORATION HARVESTLAND FOODS INC FLEET BANKING INDUSTRIES GREAT LAKES PRODUCTS HOLLY TEXTILES INTERNATIONAL COASTLINE INC WESTER CORPORATION HORIZON LABORATORIES FIRST DOWNEY INC MORRISON HOME FEDERATION SIGNAL/WEST PETROLEUM GULF LAND USA A PLAINFIELD IN WORCESTER MA BOSTON MA ST. LOUIS PARK MN MILWAUKEE WI 972047204 461686168 016041604 021992199 554265 426 532023202 235103510 600740074 .00 .00 .00 528.84 .00 .00 .00 .00 850815 850815 850815 A 0430 0450 A 850815 18645 18715 18785 19030 01565 01600 19485 20430 20710 VA A 850815 850815 IL A 0470 0490 0510 0530 NORFOLK PROSPECT HGTS LOS ANGELES DALLAS CA A .00 900540054 752345234 850815 850815 TX A .00
question.
CUSTOMERS CUSNO NAME CITY ST ZIP CRED OPEN $ YTD SALES ACT DT SLMN ID 0030 CANNON TOOLS CO ATLANTA GA A 3322123.00 34222 NY A 0090 0130 0150 INTERNATIONAL BANK CORP SUN DIAL CITRUS GROWERS NEW YORK LOS ANGELES 303012334 100059989 902130000 100190000 282552550 CA 21165 29390 A 860220 850815 850815 850815 850815 NEW YORK NY A 0170 CHARLOTTE NC A 23442.00 .00 21489.00 .00 .00 .00 .00 931.72 .00 13150 31420 17980 0190 CA A IMPERIAL BANKCORP UNITED ATLANTIC SHARES SOUTHWEST STATE OIL REFINING WEST LIFE INSURANCE CHEMICAL MUTUAL MICHIGAN LIGHTING INC. 850815 0210 SHERMAN OAKS BALTIMORE FORT WORTH MD A 00655 00725 TX A AZ A 914231423 212031203 761026102 850365036 181018101 303310331 940024002 968426842 850815 860220 850815 850815 850815 PA A PHOENIX ALLENTOWN ATLANTA SAN MATEO HONOLULU HARTFORD IRON WORKS INC NATIONAL HARRIS CORPORATION GA A 0230 0250 0270 0290 0310 0330 0350 0370 0390 0410 .00 .00 3457.00 .00 CA 18260 00760 00795 01075 18610 01145 А 211650.00 293900.00 131500.00 314200.00 179800.00 6550.00 7250.00 182600.00 7600.00 7950.00 10750.00 186100.00 11450.00 186450.00 187150.00 187850.00 190300.00 15650.00 16000.00 194850.00 204300.00 207100.00 HI A 850815 850815 850815 PORTLAND OR A A 850815 A CARTERET STEEL CORPORATION HARVESTLAND FOODS INC FLEET BANKING INDUSTRIES GREAT LAKES PRODUCTS HOLLY TEXTILES INTERNATIONAL COASTLINE INC WESTER CORPORATION HORIZON LABORATORIES FIRST DOWNEY INC MORRISON HOME FEDERATION SIGNAL/WEST PETROLEUM GULF LAND USA A PLAINFIELD IN WORCESTER MA BOSTON MA ST. LOUIS PARK MN MILWAUKEE WI 972047204 461686168 016041604 021992199 554265 426 532023202 235103510 600740074 .00 .00 .00 528.84 .00 .00 .00 .00 850815 850815 850815 A 0430 0450 A 850815 18645 18715 18785 19030 01565 01600 19485 20430 20710 VA A 850815 850815 IL A 0470 0490 0510 0530 NORFOLK PROSPECT HGTS LOS ANGELES DALLAS CA A .00 900540054 752345234 850815 850815 TX A .00