Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

c) Scores(Team, Day, Opponent, Runs) Gives the scores in the Japanese Baseball League for two consecutive days. The Opponent is NULL if the Team did

image text in transcribed

c) Scores(Team, Day, Opponent, Runs) Gives the scores in the Japanese Baseball League for two consecutive days. The Opponent is NULL if the Team did not play on that day. The number of Runs is given as NULL if either the team did not play, or will play on that day but the game is not yet concluded. The data in this table is as follows: (5) Day Opponent Runs Team Dragons Sunday Swallows 4 TigersSunday Bay Stars 9 Carp Swallows Sunday Dragons 7 Bay Stars SundayTigers 2 GiantsSunday NULLNULL Dragons Monday Carp TigersMonday NULL NULL Carp Swallows Mondav Giants 0 Bay Stars Monday NULL NULL Giants Mondav Swallows 5 Sunday NULLNULL NULL Monday Dragons NULL What is the result of executing on this data the query: SELECT Team, Day FROM Scores WHERE Opponent IS NULL OR NOT (Runs0)

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

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

More Books

Students also viewed these Databases questions