3) Generate the following output with proper column headings. A Currency ith al

Question

3) Generate the following output with proper column headings. A Currency ith al A Currency to the A Currency to the A Currency to the 567 8876 567.9 2567.89 4) List the 13 states where vendors are located where the name of the state is between the letters E and P exclusive. State MO INC IND 5) Show rows containing: invoice number, line item description and line item amount for all line items where the invoice date is greater than 2014-07-23. Should return 10 rows 53253249 Freicht 547480 102 0-2436 263253257 Freiaht 34116 7/222 963253240 Frecht 27.75 224.00 Health Inaurance VSAM book orintina 10976.06 2.57 Card deck advertsing 0.36 Crash Course covers 1000.6 67.00 689.99 3517.58 503.20 319447 Precht DB2 book orintino Bronco lease 6) Display the vendor_name and vendor zip_codes of those companies that have the same zip code as another company. List each company only once. Should retrieve 39 rows. Order by zip code. First 10 are below 19:70 19170 Daress Meda. Inc. Laboratories. Dnc Roadmay Packace Satrm Ie Bll Marvin Electric Inc ASC Sions The Presort Center 91135 93706 Yaie Industid Truos Fresno 93706

Explanation / Answer

1.

SQL> COLUMN DECIMAL HEADING A Currency with all decimals

SQL> COLUMN DOLLAR HEADING A Currency to the dollar

SQL> COLUMN PENNY HEADING A Currency to the Penny

SQL> COLUMN DIME HEADING A Currency to the Dime

SQL> SELECT DECIMAL, DOLLAR, PENNY, DIME FROM Currency;

2.

SQL> SELECT STATE FROM VENDORS WHERE STATE BETWEEN 'E' AND 'P';

3.

SQL> SELECT invoice_number, line_item_description,line_item_amount FROM line_items where invoice_date >'2014-07-23' LIMIT 10;

4.

SQL> SELECT DISTINCT vendor_name, vendor_zip_codes FROM COMPANY WHERE zip_code1=zip_code2 ORDERBY zip _code LIMIT 39;

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.