Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SELECT type FROM doughnut_ratings WHERE location = 'Krispy King' AND rating 6; Answer:?? SELECT type FROM doughnut_ratings WHERE location = 'Krispy King' AND rating =

image text in transcribed

SELECT type

FROM doughnut_ratings

WHERE location = 'Krispy King' AND rating 6;

Answer:??

SELECT type

FROM doughnut_ratings

WHERE location = 'Krispy King' AND rating = 3;

Answer:??

SELECT type

FROM doughnut_ratings

WHERE location = 'Snappy Bagel' AND rating >= 6;

Answer:??

SELECT type

FROM doughnut_ratings

WHERE location = 'Krispy King' OR rating > 5;

Answer:??

SELECT type

FROM doughnut_ratings

WHERE location = 'Krispy King' OR rating = 3;

Answer:??

SELECT type

FROM doughnut_ratings

WHERE location = 'Snappy Bagel' OR rating = 6;

Answer:??

Question 7 Based on the table below, fill in the resulting values produced by each of the following SQL Queries doughnut ratings location time date type rating comments Krispy King8:50 9/27 plain glazed10 almost perfect am Duncan's Do- 8:59 8/25 NULL greasy nuts am Starbuzz Coffee 7:35 5/24 cinnamon 5 stale, but tasty cake Duncan's Do- 7:03 4/26 jelly nuts not enough elly

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_2

Step: 3

blur-text-image_3

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

Logic In Databases International Workshop Lid 96 San Miniato Italy July 1 2 1996 Proceedings Lncs 1154

Authors: Dino Pedreschi ,Carlo Zaniolo

1st Edition

3540618147, 978-3540618140

More Books

Students also viewed these Databases questions

Question

8. Explain the relationship between communication and context.

Answered: 1 week ago