Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question# 2 : ( Select one answer ) What does the following code do ? SELECT * FROM customer WHERE zip = ' 9 8

Question#2:
(Select one answer)
What does the following code do?
SELECT * FROM customer WHERE zip ='98118' OR zip ='98092' AND balance >5000;
I
a) shows customers with zipcodes of either 98118 or 98092-but only ones with a balance of over $5,000.
b) shows customers wth zipcodes in either 98118 or 98092 but does not check the balance of the customers.
c) shows customers with zipcodes of either 98118 and 98092 but only customers in 98092 that have a balance over $5,000.
d) shows customers with a balance of over $5,000 but does not check zipcodes.
image text in transcribed

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

Database Processing Fundamentals Design And Implementation

Authors: David M. Kroenke

5th Edition

B000CSIH5A, 978-0023668814

More Books

Students also viewed these Databases questions

Question

Create a Fishbone diagram with the problem being coal "mine safety

Answered: 1 week ago