Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Beginner JAVA code please. Need ASAP. If possible, add comments so I can learn as well. Thank you in advance! 4) Find all phone numbers

image text in transcribedimage text in transcribed

Beginner JAVA code please. Need ASAP. If possible, add comments so I can learn as well. Thank you in advance!

4) Find all phone numbers in the Person.Phone Number table that have area code 415. 1 2 3 4 5 6 Phone Number 415-555-0114 415-555-0115 415-555-0121 415-555-0123 415-555-0124 415-555-0131 415-555-0138 415-555-0147 415-555-0170 415-555-0174 415-555-0197 7 8 9 10 11 2 5) Find all phone numbers in the Person.Phone Number table that have area code other than 415. 1 3 4 5 Phone Number 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 1 (11) 500 555-0110 6 7 8 9 10 11 6) Return all products whose list price is between $15 and $25 in the Production. Product table. 1 3 4 ProductID 843 844 845 858 859 860 5 Name Cable Lock Minipump Mountain Pump Half-Finger Gloves. S Half-Finger Gloves, M Half-Finger Gloves, L Fender Set - Mountain LL Mountain Tire LL Road Tire ML Road Tire Chain 6 7 878 00 9 928 931 932 952 10 11 7) Using the Sales.Store table, write a query that returns only the one row in which the customer ID (Business EntityID) starts with the number 1 and the store name begins with Bicycle: 3 1 Business EntityID 1020 1426 1858 Name Bicycle Warehouse Inc. Bicycle Merchandise Warehouse Bicycle Lines Distributors 2 3

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

IRS Audit Protection And Survival Guide Trucking Industry

Authors: Daniel J. Baran, Gerald F. Bernard, James E. Brown

1st Edition

0471166413, 978-0471166412

More Books

Students also viewed these Accounting questions

Question

Conduct a needs assessment. page 269

Answered: 1 week ago