Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can I get help with 4, 5, and 6. I need the SQL synatx that I. need to use on the terminal/ commamd window EXERCISE

image text in transcribed
image text in transcribed
Can I get help with 4, 5, and 6.
I need the SQL synatx that I. need to use on the terminal/ commamd window
EXERCISE Using the Ch07_SaleCo database (ER Diagram attached), use SQL queries to answer the following questions. For each question, show the query and some evidence (screen shot, copy of the output) of your query's success. 1. For all customers with non-zero balances in the 615 area code, list the full customer name. 2. For products with fewer than 15 items in stock (P_QOH), list the product description and price. Relabel the report columns with more understandable headings. 3. Assuming that the discount column in the product table is available to preferred customers, report the discounted price of products for all products with a before discount price of more than $100. 4. Customer Anne Farriss has called, asking for a listing of her invoice numbers and dates. 5. Corporate Management would like a list of all products sold by companies located in Florida, 6. Customer Anne Farriss called back and would like a complete account. This listing will need her name, phone number and balance, and invoice information CUSTOMER CUSCODE INT(11) CUS LNAME VARCHAR(15) CUS FNAME VARCHAR(15) CUS_INITIAL CHAR(1) CUS AREACODE CHAR(3) CUS PHONE CHAR(B) CUS BALANCE DECIMAL (9,2) indi PRODUCT P.CODE VARCHAR(10) P_DESCRIPT VARCHAR(35) P NDA TE DATETIME P QOH INT|11) P_MIN INT11) P.PRICE DECIMAL(8.2) P DISCOUNT DECIMAL(4.2) V.CODE INT(11) VENDOR V_CODE INT(11) OV NAME VARCHAR(35) V_CONTACT VARCHAR(15) V AREACODE CHAR(3) V_PHONE CHARIS) V STATE CHAR(2) V ORDER CHAR(1) INVOICE INV_NUMBER INT(11) CUS_CODE INT(11) INV_DATE DATETIME de se UNE INV_NUMBER INT(11) LINE NUMBER DECIMALI2,0) KP_CODE VARCHAR(10) LINE UNTDECIMAL19.21 LINE PRICE DECIMAL/9,2)

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

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions

Question

What is Change Control and how does it operate?

Answered: 1 week ago

Question

How do Data Requirements relate to Functional Requirements?

Answered: 1 week ago